Formulas & Functions
 

I am trying to have a formula with the following datas:
IF C2 equal "Blue"; Sheet1!G3; and make A1=D2.
I typed the formula like this: IF(C2="Blue";Sheet1!G3);AND(A1=D2)
What I need is to have two results with just one command, that means, when I
type Blue on C2, G3 will mark Blue and the content of cell A1 should be
transported to the blank cell D2
I get FALSE, because instead to MAKE, the formula is reading as if A1 is
equal to D2, and my goal is to transport the content of the cell A1 to the
blank cell D2.
I would thank very much to whom will help me.
Thanks in advancing.
Tadu

--
Tadu

You can't, a formula can only return a value in the cell where it resides so
you would need 2 formulas one in
A1 and one in Sheet!!G3
so in cell A1 use =IF(C2-"Blue",D2,"") I don't understand what you want in
G3 though, do you mean

=IF(C2="Blue",C2,"")

in Sheet1!G3

put the sheet name where C2 is in the last formula assuming they are in
different sheets
--
Regards,

Peo Sjoblom


"Tadu" wrote in message
...
I am trying to have a formula with the following datas:
IF C2 equal "Blue"; Sheet1!G3; and make A1=D2.
I typed the formula like this: IF(C2="Blue";Sheet1!G3);AND(A1=D2)
What I need is to have two results with just one command, that means, when
I
type Blue on C2, G3 will mark Blue and the content of cell A1 should be
transported to the blank cell D2
I get FALSE, because instead to MAKE, the formula is reading as if A1 is
equal to D2, and my goal is to transport the content of the cell A1 to the
blank cell D2.
I would thank very much to whom will help me.
Thanks in advancing.
Tadu

--
Tadu