Thank you so much, I will try it! Been struggling with it.
--
Lisa
LifeHapins


"~slacker~" wrote:

is this what you are looking for/

=IF(AND(A1<=3000,B1<=10,C1<=5),"Class
I",IF(AND(A13000,A1<=10000,B110,B1<=12,C15,C1<= 10),"Class
II",IF(AND(A110000,B112,C110),"Class III","")))