Hi there,

I am trying to get a nested function to work for me and I have seriously been working on it off-and-on for hours.

Basically I am setting up a fantasy sports spreadsheet that calculates everything for me. I have an AVERAGE YARDS PER GAME column and a BONUS column which gives the player extra bonus points if they average a certain amount of yards per game. This is how the bonus works:

Average 0-299 yards/game = 0 points
Average 300-399 yards/game = 4 points
Average 400-499 yards/game = 6 points
Average 500+ yards/game = 8 points

This is what I have, but it is not working. Can you help!?! Thanks in advance!! NOTE: D4 is the cell where the player's AVERAGE YARDS PER GAME will be listed and of course this formula is going in the cell under the BONUS column.

=IF(D4>499,8,IF((300<=D4<=399),4,IF((400<=D4<=499),6,0)))

0-499 just gets me 0 in the cell, but of course for 300-399 I want 4 and for 400-499 I want 6. 500+ DOES give me a value of 8, however.

THANKS!!!