Hi Connie

how about
=IF(OR(B2<=5,B2=15),"this answer",IF(B2<9,"this answer
printed",IF(B2<13,"then this is the correct answer","now this is the correct
answer")))


--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"Connie" wrote in message
...
I am setting up a datasheet needing multi if/then statements. It's a
questionaire with 7 questions and points for each answer given. I already
have it set up for the total of these points, but now I need the answers
printed into one cell.
IF(b25<9, "this answer printed")
IF(b28<13, "then this is the correct answer")
IF(b212<15,"now this is the correct answer)
all else gives "this answer"

I have found that I can put each of these into their own cells (non
printing) and THEN have the desired cell find the one cell with something
printed, but what a chore. But is this my only option? Considered look up
charts if I have to. Never done one, though, so again another learning
experience.

Thanks for any help. This is fun, but frustrating.....