I'd like to make a formula that does this..

G

Garnet

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

Don Guillett

try this. Notice I start with the HIGHEST first
=IF(A2>29,3,IF(A2>19,2,IF(A2>9,1,"")))
 
E

Emily

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

=IF(AND(A5>10,A5<19),1,IF(AND(A5>20,A5<29),2,...))
 
Top