If and formula

Stephen · Feb 25, 2009

Hi Folks,

APparently I left my brain at home this morning cuase for the life of me I
can't figur eout how to write a statement that says "If G2 is greater than 0
and less than 31, place the value of H2 here."

TIA...

Mike H · Feb 25, 2009

Stephen,

We all have those days

=IF(AND(G2>0,G2<31),H2,"")

Mike

Bony Pony · Feb 25, 2009

=if(and(g2>0,g2<31),h2,"")

Stephen · Feb 25, 2009

Perfect, thanks!

Rock on brother!

Mike H said:
Stephen,

We all have those days

=IF(AND(G2>0,G2<31),H2,"")

Mike

Stephen · Feb 25, 2009

YOu guys are the best...

Thank you!

Bony Pony said:
=if(and(g2>0,g2<31),h2,"")

Bony Pony · Feb 27, 2009

You're very welcome.

Stephen said:
YOu guys are the best...

Thank you!