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