Excel - If then statement for commission

October 2016


I am trying to set up an if then formula that would basically say


So if the value is greater than 750 I want the result to be 750, if it is lower, I would like it to show the actual value. Or even the value in a newly established column that contains the answer.


The correct formula is :


Those double quotes should not be there.


Thanks to venkat1926 for this tip on the forum.

Related :

This document entitled « Excel - If then statement for commission » from CCM (ccm.net) is made available under the Creative Commons license. You can copy, modify copies of this page, under the conditions stipulated by the license, as this note appears clearly.