Thread: I'd like to make a formula that does this..
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Duke Carey
 
Posts: n/a
Default 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!


Reply With QuoteReply With Quote