So if the cell into which they enter the value, and which you wish to test
against 1500, is J19, not A1, what change do *you* think you should make to
the formula
=(J19-N19)*50%*E19*if(A1=1500,65%,1) ?

And if the 1500 value is a variable stored in N19, what other change could
you make?

[If the value in N19 is 1500, I assume that you're happy that you'll be
getting negative results when J19 is less than 1500?]
--
David Biddulph

"Jim" wrote in message
...
Duke, thanks for your help. Unforunatly it is nt working.
The goal is to be able to type the sale price into J19. If that price is
1500 or greater I need the formula to then subtract 1500 from the total,
divide it in half and deduct 35% from the total.

If it is less then 1500 I need the same formula minus the 35% reduction.

Sorry to be a pain...does this help?

"Duke Carey" wrote:

Assuming the cell they enter the value in is A1

Try

=(J19-N19)*50%*E19*if(A1=1500,65%,1)

"Jim" wrote:

My goal is to have a cell that if a person enters 1500 or higher it
uses this
formual: =(J19-N19)*50%*E19*65% and if they enter less then 1500 it
uses this
formula =(J19-N19)*50%*E19 does anyone know if this is possible?