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.....