Put =(A7<1.01)*(A7.76)*H3 in cell G2. If A7 is not between .76 and 1.01 you
will get zero.
--
Gary's Student


"WALOTT1" wrote:

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?