If then statement for commission

Closed
Melissa - Dec 10, 2009 at 05:55 PM
venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Dec 10, 2009 at 08:01 PM
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

venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 810
Dec 10, 2009 at 08:01 PM
the correct formula is

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

those double quotes should not be there.
0