Newbie Needs "If greater than, but less than" statement" Formula Help

Try...

=IF(AND(I3>=22.5,I3<=30),"65", IF(AND(I3>=15.01,I3<=22.5),"70", IF(AND(I3>=13.51,I3<=15),"77.5", "No Match")))

Edit: Lets try to explain this in a little more detail and hope that the site doesnt crash again. :-)

The way an IF statement works in Excel is as such...

=IF("This is true", "Do this", "Else do this")

AND works like this...

=AND("If this is true", "and this is true", "and this is true", "etc") return "TRUE"

What you did in your formula is conflate the parameters of the IF and AND function, specifically the "65" [AND(I3>=22.5,I3<=30,"65")]. That belongs outside the AND parentheses but within the IF's, as such...

IF(AND(I3>=22.5,I3<=30),"65")

Note that in the above the only parameters we are using are...

=IF("This is true", "Do this")

In my corrected formula you will notice that I am nesting IF statements...

=IF("This is true", "Do this", IF("This is true", "Do this", IF("This is true", "Do this", "Else do this")))

Make sure you keep track of your parentheses. Excel will try to help but doesn't always do so accurately.

Here is a formula that is a little easier to expand but isn't necessarily "better."

Formula:

Please Login or Register  to view this content.

If your data is in increments of 0.01 then add 0.01 to the upper limit of each range, as shown.