If then statement for commission

Closed
Melissa - 10 Dec 2009 à 17:55
venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 - 10 Dec 2009 à 20:01
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 response

venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 811
10 Dec 2009 à 20:01
the correct formula is

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

those double quotes should not be there.