conditional formulas

  • Thread starter Thread starter Guest
  • Start date Start date
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.
 
Hi!

Try this:

=IF(AND(B23>=50000,B23<=75000),7500+(B23-50000)*E8,"Your message here")

Biff
 
Back
Top