Error - template LAYOUT-DATA-WRAPPER not found

A configuration error was detected in the CGI script; the LAYOUT-DATA-WRAPPER template could not be found.

Error - template STYLE-SHEET not found

A configuration error was detected in the CGI script; the STYLE-SHEET template could not be found.

Error - template SUB-TOP-BANNER not found

A configuration error was detected in the CGI script; the SUB-TOP-BANNER template could not be found.

Subject:	Re: help with formula
From:	Byron Wolter <[log in to unmask]>
Reply To:	PCSOFT - Personal Computer software discussion list <[log in to unmask]>
Date:	Sat, 25 Jan 2003 00:50:59 -0600
Content-Type:	text/plain
Parts/Attachments:	text/plain (35 lines)

Thanks.  It works. I had almost the same formula, except I was putting the
AND in the wrong place.

Byron Wolter



Try this:
=IF(AND(G5="x",H5="x",I5="x"),"Plan A",IF(AND(G5="x",H5="x",I5=""),"Plan
B",IF(AND(G5="",H5="",I5="x"),"Plan C","Plan D")))

There are other ways to get the same result by rearranging some of the
logic, but this is an example of a possible solution.


-----Original Message-----
Need help. My school has failed to supply me with the instructor's book
for my Office 2000 class.  I have some students in Advanced Excel 2000
and an assignment calls for a formula for which I just don't have a
clue.

It goes like this. If cell G5 and H5 and I5 all have an "X" in them,
then it should print "Plan A". If cell G5 and H5 (no I5) both have an
"x" in them, then print "Plan B". If only I5 has an "X", then print
"Plan C". If none have an x, then print "Plan D".  the assignment says
to use a nested IF function.  The "X" is literal, only an X is in the
cell. I got somewhere, but it didn't work after it looks at G5.  Can
anyone help?

Byron Wolter

                         PCSOFT's List Owner's:
                      Bob Wright<[log in to unmask]>
                       Drew Dunn<[log in to unmask]>

ATOM RSS1 RSS2

LISTSERV.ICORS.ORG