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
Bookmarks