conditional formulas
 

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.

=IF(and(B2350000,B23<75000),7500+(B23-50000)*E8,"Try Again")

"Paul Sheats" wrote:

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.

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.