IF AND

  • Thread starter Thread starter TeeSee
  • Start date Start date
T

TeeSee

Could someone please suggest a formula that would go something
like .....

If A1 is less than 36 then result =1 else IF A1 is =36 but less than
72 then result =2 etc.

Thanks
 
=IF(A1<36,1,IF(OR(A1=36,A1<72),2,"FalseCondition"))

You'll be limited to 7 nested functions. Depending on how many more
conditions there will be, you may find that making a table and using VLOOKUP
will be the way to go.

Regards,
Paul
 
Try =IF(A1="","",IF(A1<36,1,IF(A1<72,2,IF(A1<96,3,4))))
I think the number of nested IF's is 7 though.
Sandy
 
Back
Top