Thread: If and formula
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Stephen Stephen is offline
external usenet poster
 
Posts: 106
Default 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...