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
 
This is not an IF problem. It is math: =INT(A1/36)+1

best wishes
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Need Countifs Formula Help 0
CONDITIONAL FORMATTING QUERY 0
Subtracting hours and minutes with negative times 2
Simple IF() formula 5
Calculate Width of String, not Length? 'Em' not 'Kearning'? 2
Converting from Decimal to Base-36 in Excel Formula 8
Figuring out a lengthy formula. Probably quite simple... 3
Excel 2007 print option gone 1

Back
Top