Greater Than 24 But Less Than 48 - If Statement

  • Thread starter Thread starter Workbook
  • Start date Start date
W

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?
 
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?
Click to expand...

Try this formula:

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

Hope this helps / Lars-Åke
 
Thank you, this is very helpful to me.

Lars-Ã…ke Aspelin said:
Try this formula:

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

Hope this helps / Lars-Ã…ke
Click to expand...
 
Back
Top