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

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!

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

try this. Notice I start with the HIGHEST first
=IF(A229,3,IF(A219,2,IF(A29,1,"")))
--
Don Guillett
SalesAid Software

"Garnet" wrote in message
...
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!

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

Maybe

=int(A2/10)


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

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

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!