Formulas

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
Click to expand...

It appears that you are using the spreadsheet program Excel. This
newsgroup is for a different program, Microsoft Access, the database
program in the Office Pro suite.

Please repost your question in one of the microsoft.public.excel
newsgroups.

John W. Vinson[MVP]
 
Back
Top