Byron -
Peter's suggestion is very close depending on how picky you want to be
with the logic. What if there is an single X in either G5 or H5? It
may be that the correct answer should be a blank cell. If so then you
would need to put a condition on "Plan D" so it only matches all blank
cells in G5:I5.
=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",IF(ISBLANK(G5:I5),"Plan
D",""))))
If you don't want to leave the results blank, so you can tell it is
working for each possible condition, you could put some text in the
last set of double quotes. i.e. ...,"Plan D","No Match")))) This would
of course be determined by how the question is actually written.
Sorry if this in nitpicking...
Mike
--- Peter Shkabara <[log in to unmask]> wrote:
> 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.
>
> Peter
> --------------------------------------------------------------------
> [log in to unmask] - http://gocolumbia.org/pesh
>
>
> -----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
>
> The NOSPIN Group is now offering Free PC Tech
> support at our newest website:
> http://freepctech.com
__________________________________________________
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com
The NOSPIN Group Promotions is now offering
Mandrake Linux or Red Hat Linux CD sets along
with the OpenOffice CD... at a great price!!!
http://freepctech.com/goodies/promotions.shtml
|
