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

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