Thread: Greater Than 24 But Less Than 48 - If Statement
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Workbook Workbook is offline
external usenet poster
  
Posts: 121
Default Greater Than 24 But Less Than 48 - If Statement
Thank you, this is very helpful to me.

"Lars-Åke Aspelin" wrote:

On Tue, 3 Feb 2009 12:43:01 -0800, Workbook
wrote:

I want a 1 to appear in cell N2 if in cell M2 I have greater than 24 but
less than 48. This is the IF statement that I have so far in cell N2.
=IF(Sheet1!M2=25,1,""). What do you think?

Try this formula:

=IF(AND(Sheet1!M224,Sheet1!M2<48),1,"")

Hope this helps / Lars-Åke


Reply With QuoteReply With Quote