# SolvedIF Statement

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

#### faraz28

Hi there,

I can't figure out how to properly write an IF statement for this specific scenario. I have to calculate E.I (Employment Insurance).
E.I is 1.27% of your gross income. If my annual gross income is for example \$66'000 I'd type in the formula
=(C7*1.27)/100 (C7 is the cell with the gross income.)

The max annual you can get is \$836.19 annually. For this I have to write an IF statement.
My initial IF statement was
=(C7*1.27)/100 & IF(C7>836.19,"836.19","")
This gives me an error.

#### DaveA

David
Spam Fighter
What program are you trying this in?

#### cwwozniak

Chuck
Moderator
Hi faraz28, and welcome to TSG.

If you are using MS-Excel, I don't understand why you are using the concatenate text function in your formula. Also, using the MIN() function is probably simpler than using an IF function.

Code:
``=MIN(C7*0.0127,836.19)``

#### etaf

Wayne
Moderator
gross @ 1.27% maximum payout is 836.19, so if the 1.27% is = to or greater than 836.19 , the result is 836.19 otherwise calculate the amount

in excel
=IF((c7*1.27)/100 >=836.19, 836.19, (C7*1.27)/100)

#### faraz28

gross @ 1.27% maximum payout is 836.19, so if the 1.27% is = to or greater than 836.19 , the result is 836.19 otherwise calculate the amount

in excel
=IF((c7*1.27)/100 >=836.19, 836.19, (C7*1.27)/100)
Thanks a lot for your help. It worked!

#### faraz28

Hi faraz28, and welcome to TSG.

If you are using MS-Excel, I don't understand why you are using the concatenate text function in your formula. Also, using the MIN() function is probably simpler than using an IF function.

Code:
``=MIN(C7*0.0127,836.19)``

#### faraz28

What program are you trying this in?
I was using Excel. Sorry for not specifying.

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

As Seen On