Yes, change e19<1500 to j19<1500.

By the way Duke and BJ have good comments as well

"Jim" wrote:

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

"Brad" wrote:

Assuming that 1500 is input in E19

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

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