G
Guest
I am having a difficult time with a particular function. Here is my formula
so far:
=IF(OR(B23>50000,B23<75000),7500+(B23-50000)*E8)
My problem is that if the number is entered into B23 is 0, then the value in
the formula cell is a negative number.
What I want to have happen is that if a number is entered into B23 that does
not fall between 50,000 and 75,000, the cell will read something like....NO
CALCULATION AVAILABLE; TRY ANOTHER NUMBER, etc.
Can someone help? Thank you.
so far:
=IF(OR(B23>50000,B23<75000),7500+(B23-50000)*E8)
My problem is that if the number is entered into B23 is 0, then the value in
the formula cell is a negative number.
What I want to have happen is that if a number is entered into B23 that does
not fall between 50,000 and 75,000, the cell will read something like....NO
CALCULATION AVAILABLE; TRY ANOTHER NUMBER, etc.
Can someone help? Thank you.