Previous Topic Next Topic

If then statement for commission

Closed
Melissa - Dec 10, 2009 at 05:55 PM
venkat1926 Posts 1863 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 response

Answer 1 / 1
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
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.

Similar discussions

Alteryx Designer Problem with IF Statement
chintuk -
chintuk -

0 responses
Removing " false" value in "IF"
JIN -
share -

10 responses
Excel - IF function with multiple words
Nick -
user -

14 responses
If Statement Excel
KoTTen -
vcoolio -

1 response