Expert Solution - Excel IF Problems

Question description:
This user has given permission to use the problem statement for this blog.

i need a formula for a raise for each employee that also varies if they are working in two different cities as it varies by percentage

Solved by D. H. in 19 mins

This is the chat thread from the real Excelchat help session. It contains no private user information.

Excelchat Expert 01/05/2018 - 06:23

Hi there!

User 01/05/2018 - 06:23

Hello

User 01/05/2018 - 06:23

I need a formula urgently

User 01/05/2018 - 06:23

IF formula

User 01/05/2018 - 06:24

nested if

Excelchat Expert 01/05/2018 - 06:24

Sure thing I'd love to help. Yes exactly what I was thinking as well given your problem description.

Excelchat Expert 01/05/2018 - 06:24

Are you able to share your file? Or do you want to make an example in the google sheet?

User 01/05/2018 - 06:25

I need to calculate the raise for each employee based on their annual salary. I use the annual salary but it also changes by 3.5% if from Austin or Nashville and 2.5% from another

User 01/05/2018 - 06:25

I can't

User 01/05/2018 - 06:25

My boss will yell at me

User 01/05/2018 - 06:25

I'll make an example

Excelchat Expert 01/05/2018 - 06:25

haha! Understood -

Excelchat Expert 01/05/2018 - 06:26

ok awesome

Excelchat Expert 01/05/2018 - 06:26

Maybe cut and paste a section of it or something into the google sheet

User 01/05/2018 - 06:28

This is what it looks like

User 01/05/2018 - 06:29

this is it

User 01/05/2018 - 06:29

now i have to make a nested if formula for this

Excelchat Expert 01/05/2018 - 06:29

Is the bonus to be added to their annual salary?

User 01/05/2018 - 06:30

but it is difficult and i can't seem to figure it out

User 01/05/2018 - 06:30

yes

Excelchat Expert 01/05/2018 - 06:30

so they get the bonus if applicable, AND also an extra 3.5% OR 2.5% depending on what city they are in?

User 01/05/2018 - 06:30

it could yes

Excelchat Expert 01/05/2018 - 06:30

So we also need a city column Yes? Where is it on your sheet?

User 01/05/2018 - 06:30

yes*

Excelchat Expert 01/05/2018 - 06:30

column F?

Excelchat Expert 01/05/2018 - 06:31

I see it :)

Excelchat Expert 01/05/2018 - 06:31

One more question

User 01/05/2018 - 06:31

okay

Excelchat Expert 01/05/2018 - 06:32

the 2.5% or 3.5%.... is that applied AFTER the bonus? (like, they get their bonus added to their salary, and then that new number is used for the 2.5 or 3.5 %

User 01/05/2018 - 06:32

new number, years is the first thing for the salary and their city also effects the salary increase

User 01/05/2018 - 06:32

it is very confusing

Excelchat Expert 01/05/2018 - 06:32

I gotcha :)

Excelchat Expert 01/05/2018 - 06:33

You're right, it's a nested IF with a + in the middle.

Excelchat Expert 01/05/2018 - 06:33

I will code it now for you

User 01/05/2018 - 06:33

okay thank you

User 01/05/2018 - 06:33

i should get an answer of $1734

User 01/05/2018 - 06:33

when i did the math on my own this is what occurs

User 01/05/2018 - 06:36

is it working?

Excelchat Expert 01/05/2018 - 06:36

Not yet, I need a bit more time.

User 01/05/2018 - 06:36

okay, no rush

Excelchat Expert 01/05/2018 - 06:37

I almost have it

Excelchat Expert 01/05/2018 - 06:37

I think :)

User 01/05/2018 - 06:37

thank you so much

Excelchat Expert 01/05/2018 - 06:39

So lets take the example

Excelchat Expert 01/05/2018 - 06:39

annual salary 54000

Excelchat Expert 01/05/2018 - 06:39

1 year of service, so no bonus

Excelchat Expert 01/05/2018 - 06:39

from austin, so gets 3.5%

Excelchat Expert 01/05/2018 - 06:40

54000 * 3.5% = 1890

User 01/05/2018 - 06:40

yes

Excelchat Expert 01/05/2018 - 06:40

how did you get 1734

User 01/05/2018 - 06:40

but it must be =IF

Excelchat Expert 01/05/2018 - 06:40

The first part I used IFS instead of IF... is that an issue? The second part of the formula uses IF

User 01/05/2018 - 06:41

the new salary should be $55,734

User 01/05/2018 - 06:41

i'm not sure but the answer key says this

Excelchat Expert 01/05/2018 - 06:41

That new salary doesn't make sense!

User 01/05/2018 - 06:41

i know

Excelchat Expert 01/05/2018 - 06:41

I can make the IFS into multiple IF'S if you need it

User 01/05/2018 - 06:41

yes

User 01/05/2018 - 06:42

i need that