Greater Than 24 But Less Than 48 - If Statement

[Workbook]

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?

 

[Lars-Åke Aspelin]

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!M2>24,Sheet1!M2<48),1,"")

Hope this helps / Lars-Åke

 

[Mike H]

Hi

Try this

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

Mike

 

[Workbook]

Thank you, this is very helpful to me.

Try this formula:

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

Hope this helps / Lars-Ã…ke

 

[Workbook]

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

Ed