If and formula

[Stephen]

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]

Stephen,

We all have those days

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

Mike

 

[Bony Pony]

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

 

[Stephen]

Perfect, thanks!

Rock on brother!

Stephen,

We all have those days

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

Mike

 

[Stephen]

YOu guys are the best...

Thank you!

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

 

[Bony Pony]

You're very welcome.

YOu guys are the best...

Thank you!