If then statement for commission

[Closed]
Report
-
Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
-
Hello,

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 extablished column that contains the answer.

I appreciate your help.

1 reply

Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
800
the correct formula is

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

those double quotes should not be there.

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!