View Single Post
  #2   Report Post  
N Harkawat
 
Posts: n/a
Default

On cell G2 type
=IF(AND(A7=0.76,A7<=1.01),H3,"")

Also next time refrain from using all CAPS when posting questions

"WALOTT1" wrote in message
...
I AM TRYING TO INPUT INTO A CELL, (CALL IT G2) THAT IF THE NUMBER IN
ANOTHER
CELL, (CALL IT A7) IS BETWEEN .76 AND 1.01 THEN PUT THE DATA FROM A THIRD
CELL, (CALL IT H3) IN THAT CELL (G2). HOW CAN I MAKE THIS HAPPEN?