IT WORKED! Thank you!!! I only added the AND to each statement.

But you've peaked my interest in lookups. Let's see if my manual does a
better job at explaining these!

"Harlan Grove" wrote:

Connie wrote...
WOW! Makes sense. But I'm getting an error message and can't see for
looking.
Here's my formula:
=IF(OR(l2<9,l26),"Conservative",IF(l28,L2<12)," Moderately
Conservative",IF(l211,l2<17),"Moderate",IF(l216 ,l2<20),"Moderately
Aggressive",IF(l219,l2<22),"Aggressive","")))) )

It doesn't seem to like my Conservative" in my second if-then. Does it
think
it's a duplicate of the first answer?
....
"JulieD" wrote:
....
=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")))
....

Julie's formula was first checking for values *outside* a range, B2 <=
5 or B2 = 15. You're checking for values within a range, in which case
you want to use AND rather than OR - all numbers are less than 9 or
greater than 6. Also, you'd need to use AND in each of the other IF
calls.

However, you'd be better off with a lookup.

=LOOKUP(L2,{-1E300;6.00000000000001;9;11;16;19;22},
{"";"Conservative";"Moderately Conservative";"Moderate";
"Moderately Aggressive";"Aggressive";""})