Solved Nested IF Statements Excel 2010

Microsoft Excel 2010 - windows
September 26, 2011 at 07:03:49
Specs: Windows 7 Pro, Core i3 2.13 GHz/8GB
I'm having trouble creating a nested if statement. I have to figure out how much bonus money is paid out to an employee based on their pay grade.

Pay grades:

Bonus Pay Grade 1 amount (located in cell Y2): $3,000
Bonus Pay Grade 2 amount (located in cell Y3): $6,000
Bonus Pay Grade 3 amount (located in cell Y4): $8,000

The Bonus column is I2:I101

This is what I have for my formula:

IF((I2=1,Y2, IF(I2=2,Y3, IF(I2=3,Y4))))

The program doesn't seem to like it and I'm not sure why. Is it nested correctly? Where did I go wrong? Any help would be hugely appreciated. Thanks!!!!


See More: Nested IF Statements Excel 2010

Report •

#1
September 26, 2011 at 12:30:16
This appears to be homework.
So I won't give you the answer but just ask:

Why do you have a third =IF(), what's the logic?

MIKE

http://www.skeptic.com/


Report •

#2
September 26, 2011 at 14:39:24
The logic corresponds to the third pay grade. Is that where I'm going wrong? (A yes or no will suffice). All I'm trying to do is figure out where I'm going wrong.

Report •

#3
September 26, 2011 at 15:19:35
✔ Best Answer
Yes.

Remember an =IF() function is composed of:

=IF(Logical_test , Value_if_true , Value_if_false)

You have only three conditions.

MIKE

http://www.skeptic.com/


Report •

Related Solutions

#4
September 26, 2011 at 16:02:01
Thanks! I guess I was getting confused between the fact that I need all three conditions to make it work. I even tried typing up the statement in notepad on separate lines.

Report •

#5
September 26, 2011 at 16:57:40
So what is the correct formula?

MIKE

http://www.skeptic.com/


Report •

#6
September 26, 2011 at 17:12:01
=IF(I2=1,Y2, IF(I2=2,Y3, IF(I2=3,Y4)))

Report •

#7
September 26, 2011 at 17:20:15
Close, but no cigar.

The major hint here is that you have only three conditions.

Remember:

=IF(Logical_test , Value_if_TRUE , Value_if_FALSE)

MIKE

http://www.skeptic.com/


Report •

#8
September 26, 2011 at 19:13:43
=IF([Pay Grade]=1,$Y$2,IF([Pay Grade]=2,$Y$3, $Y$4))

Report •

#9
September 27, 2011 at 03:25:46
Correct.

You only needed two =IF() statements, not three.

MIKE

http://www.skeptic.com/


Report •

Ask Question