Thread: If and formula
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default 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...