Two Formulas in one cell

J

Jim

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?
 
B

Brad

Assuming that 1500 is input in E19

=if(E19<1500,(J19-N19)*50%*E19,=(J19-N19)*50%*E19*.65)
 
V

Vasant Nanavati

In which cell is the number to be entered?

Assuming it's E19:

=(J19-N19)*50%*E19*(IF E19>=1500,0.65,1)

_____________________________________________________________________
 
D

Duke Carey

Assuming the cell they enter the value in is A1

Try


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

Jim

Brad thank you so much. The 1500 number would be put in J19...E19 is for
quantity whereas J19 if for price charged. Is that an easy change
 
D

David Biddulph

You haven't said which cell your user will be putting the data into, but if
it were A19 try =(J19-N19)*50%*E19*IF(A19>=1500,65%,1)
 
J

Jim

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?
 
B

bj

=(J19-N19)*0.5*E19*if(J19<1500,1,0.65)


Jim said:
Brad thank you so much. The 1500 number would be put in J19...E19 is for
quantity whereas J19 if for price charged. Is that an easy change
Click to expand...
 
J

Jim

Thank you all...Brad's formula did it. And it was easily editable so I could
change minmum costs of different line items. Thank you Brad
 
D

David Biddulph

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?]
 
V

Vasant Nanavati

Thanks, Roger; hope to be contributing more. :)
________________________________________________________________________
 
Top