|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.|
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!!!!