Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Functions and formulas | Excel Discussion (Misc queries) | |||
Suddenly cannot calculate functions or formulas in Excel | Excel Worksheet Functions | |||
How do I get to master Excel functions and formulas? | Excel Worksheet Functions | |||
OLAP write back via formulas (functions), not read only pivot tab | Excel Worksheet Functions | |||
calculating formulas for all workbooks in a folder | Excel Worksheet Functions |