Hi!

Try this:

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

Biff

"Paul Sheats" <Paul wrote in message
...
I am having a difficult time with a particular function. Here is my
formula
so far:
=IF(OR(B2350000,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.