If and formula
 

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...

If and formula
 

Stephen,

We all have those days

=IF(AND(G20,G2<31),H2,"")

Mike

"Stephen" wrote:

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...

If and formula
 

=if(and(g20,g2<31),h2,"")

"Stephen" wrote:

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...

If and formula
 

Perfect, thanks!

Rock on brother!

"Mike H" wrote:

Stephen,

We all have those days

=IF(AND(G20,G2<31),H2,"")

Mike

"Stephen" wrote:

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...

If and formula
 

YOu guys are the best...

Thank you!

"Bony Pony" wrote:

=if(and(g20,g2<31),h2,"")

"Stephen" wrote:

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...

If and formula
 

You're very welcome.

"Stephen" wrote:

YOu guys are the best...

Thank you!

"Bony Pony" wrote:

=if(and(g20,g2<31),h2,"")

"Stephen" wrote:

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...