View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Garnet
 
Posts: n/a
Default 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!