There is probably a better way... but here's what I would do...

=IF(AND(A510,A5<19),1,IF(AND(A520,A5<29),2,...))

"Garnet" wrote:

IF a cell A's value is greater than 10 and less than 19 then Cell B equals 1,
IF A2 is between 20 and 29 then B2 equals 2, etc, etc,

I've tried every iteration of IF statements that I know of and I'm not
getting what I want.

Thanks!