Two Formulas in one cell

[Guest]

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?

 

[Guest]

Assuming that 1500 is input in E19

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

 

[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)

_____________________________________________________________________

 

[Guest]

Assuming the cell they enter the value in is A1

Try


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

 

[Guest]

remove the second = sign
you could also use
=(J19-N19)*0.5*E19*if(E19<1500,1,0.65)

 

[Guest]

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

 

[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)

 

[Guest]

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?

 

[Guest]

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

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

 

[Guest]

Yes, change e19<1500 to j19<1500.

By the way Duke and BJ have good comments as well

 

[Guest]

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

 

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

 

[Roger Govier]

Off Topic

Vasant,
Great to see you back after a long absence.

 

[Vasant Nanavati]

Thanks, Roger; hope to be contributing more.
________________________________________________________________________