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?
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?
=IF(AND(A7>.76,A7<1.01),H3,"")
--
HTH
RP
(remove nothere from the email address if mailing direct)
"WALOTT1" <[email protected]> wrote in message
news:[email protected]...
> 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?
Try
=if(and(A7>=0.76,A7<1.01,H3,value if not true)
in G2
"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?
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" <[email protected]> wrote in message
news:[email protected]...
>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?
oops left off a parenthesis
=if(and(A7>=0.76,A7<1.01),H3,"")
in G2
"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?
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?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks