A few words of thanks would be greatly appreciated.

Excel - If then statement for commission

Latest update on January 3, 2010 at 05:24 PM by aakai1056 .

Issue
Solution
Note

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.

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
Sbi bank statement format in excel - How-To - Internet
Multiple IF statements in Excel ✓ - Forum - Excel

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).

Excel - Run a macro when opening a sheet

Credit Summation Formula Excel