Excel - If then statement for commission

March 2017



Issue


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

=IF(F4*0.2>750,"750","F4*.2")


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.

Solution



The correct formula is :

=IF(F4*0.2>750,750,F4*0.2) 


Those double quotes should not be there.

Note


Thanks to venkat1926 for this tip on the forum.

Related


Published by aakai1056.
This document, titled "Excel - If then statement for commission," is available under the Creative Commons license. Any copy, reuse, or modification of the content should be sufficiently credited to CCM (ccm.net).