# 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,000Bonus Pay Grade 2 amount (located in cell Y3): \$6,000Bonus Pay Grade 3 amount (located in cell Y4): \$8,000The Bonus column is I2:I101This 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

#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?MIKEhttp://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
 Yes.Remember an =IF() function is composed of:=IF(Logical_test , Value_if_true , Value_if_false) You have only three conditions.MIKEhttp://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?MIKEhttp://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) MIKEhttp://www.skeptic.com/

Report •

#8
September 26, 2011 at 19:13:43

Report •

#9
September 27, 2011 at 03:25:46
 Correct.You only needed two =IF() statements, not three.MIKEhttp://www.skeptic.com/

Report •