1
Thanks

A few words of thanks would be greatly appreciated.

Excel - If then statement for commission



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.
1
Thanks

A few words of thanks would be greatly appreciated.

Ask a question
CCM is a leading international tech website. Our content is written in collaboration with IT experts, under the direction of Jean-François Pillou, founder of CCM.net. CCM reaches more than 50 million unique visitors per month and is available in 11 languages.
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).

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!