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.
Related
- Excel - If then statement for commission
- Excel maximum if statements - How-To - Excel
- Excel - Using IF statement to add 1 to total - How-To - Excel
- Excel if then statements with dates - How-To - Excel
- Multiple if statements in excel data validation - Forum - Excel
- Sbi bank statement format in excel - How-To - Internet
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!
