**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

ah

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

Excelchat Expert
01/05/2018 - 06:42

Ok one sec.

User
01/05/2018 - 06:42

but i have 1 minute remaining

Excelchat Expert
01/05/2018 - 06:42

But the answer will still be 1890 for the raise

Excelchat Expert
01/05/2018 - 06:42

you can extend the timer!

Excelchat Expert
01/05/2018 - 06:42

extend another 20 minutes

User
01/05/2018 - 06:42

is it free?

Excelchat Expert
01/05/2018 - 06:42

To extend yes for sure

User
01/05/2018 - 06:42

how can i extend?

User
01/05/2018 - 06:42

once it runs out?

User
01/05/2018 - 06:42

i can just send a picture

Excelchat Expert
01/05/2018 - 06:43

Should be a button on the top right side

Excelchat Expert
01/05/2018 - 06:43

can you see it?

**This is the output file from the real Excelchat help session:**

*This is an example of the expert help you can get. It contains no private user information.*