Greater Than 24 But Less Than 48 - If Statement
 

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?

Greater Than 24 But Less Than 48 - If Statement
 

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

Greater Than 24 But Less Than 48 - If Statement
 

Hi

Try this

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

Mike

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

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

Greater Than 24 But Less Than 48 - If Statement
 

Fantastic! Thank you Mike. You're input is valuable to me.

Ed

"Mike H" wrote:

Hi

Try this

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

Mike

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