Thread: How to calculate IF, NOT, THEN, OR

Dear All,
I hope someone can help me with a spreadsheet query. I need to write formula which tells me this:

IF the value in A1 is greater than 27 or less than 32, THEN cell B1 equals zero. BUT if A1 is less than 27, B2 = the absolute value of A1 minus 27, OR IF A1 is greater than 32, B2= the value of A1 minus 32.

I hope this makes sense to someone, please let me know if I can clarify anything. Excel and I are not entirely sophisticated companions

Thankyou Kindly,
Ophidio

Hi Ophidiophobe, and welcome to the forum.

This may work for you:

=IF(A1<27,ABS(A1-27),IF(A1<=32,0,A1-32))

And I think instead of "IF the value in A1 is greater than 27 or less than 32" I think you mean (IF the value in A1 is greater than 27 and less than 32" (aka "between 27 and 32, inclusive").