Thread: If and formula
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Bony Pony[_2_] Bony Pony[_2_] is offline
external usenet poster
 
Posts: 71
Default 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...