Excel - IF Function Problem - Expert Solution

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.

Get instant expert help with Excel and Google Sheets

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.

Click here to get your free Excelchat help session

Trusted by people who work at