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.

If then statement for commission
Fenix internet on bank statement - Guide
Application for bank statement sbi - Guide
An if statement nested within another if statement will produce how many possible results? - Guide
Excel if statement - Guide
Vba case statement with string - Guide

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

Removing " false" value in "IF"

Need help to remove FALSE from cell

removing false in excel

Removing "FALSE" from an IF statement with a VLOOKUP

Removing False Value

Similar discussions

Subscribe To Our Newsletter!