Thanks, Roger; hope to be contributing more. :-)
__________________________________________________ ______________________

"Roger Govier" wrote in message
...
Off Topic

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

--
Regards

Roger Govier


"Vasant Nanavati" <vasantn AT aol DOT com wrote in message
...
In which cell is the number to be entered?

Assuming it's E19:

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

__________________________________________________ ___________________


"Jim" wrote in message
...
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?