Cell "A" Adds data to Other Cells

J

joelbeveridge

Hey People. Im looking for code that will allow me to enter a number
(1,2,3 or 4) into any "A" cell and then cell C,D,E,G in that same row
will have YES,NO,YES,YES.

E.g. I enter 1 in any "A" cell and that then adds Yes into Cell "C" -
No into Cell "D" Needs to be on the same row as the 1 entered in Cell
"A" - (and so on).

Then later I could have if you enter 2 in cell 2 it would chage the
cell informtion. From YES,NO,YES,YES to NO,NO,YES,YES. Normal stuff
like that.

Thanks for any help
 
F

Franz Verga

joelbeveridge said:
Hey People. Im looking for code that will allow me to enter a number
(1,2,3 or 4) into any "A" cell and then cell C,D,E,G in that same row
will have YES,NO,YES,YES.

E.g. I enter 1 in any "A" cell and that then adds Yes into Cell "C" -
No into Cell "D" Needs to be on the same row as the 1 entered in Cell
"A" - (and so on).

Then later I could have if you enter 2 in cell 2 it would chage the
cell informtion. From YES,NO,YES,YES to NO,NO,YES,YES. Normal stuff
like that.

Thanks for any help
Click to expand...

Hi Joelbeveridge,

I think you can use some nested IF functions in columns C, D, E and G, so
for example you could have on row 2:

C2: =IF(A2=1;"YES";IF(A2=2;"NO";IF(A2=3;"YES";IF(A2=4;"NO";""))))

D2: =IF(A2=1;"NO";IF(A2=2;"NO";IF(A2=3;"YES";IF(A2=4;"NO";""))))

and similar in E2 anda G2... You have to adjust the value of YES or NO
responging to yuor needs as consequences of values in A2...

--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy
 
J

joelbeveridge

Should i do that in VB?

Sub testmacro()
'
' testmacro Macro
' A Cell adds info to other cells
'
C2: =IF(A2=1;"YES";IF(A2=2;"NO";IF(A2=3;"YES";IF(A2=4; "NO";""))))

D2: =IF(A2=1;"NO";IF(A2=2;"NO";IF(A2=3;"YES";IF(A2=4;" NO";""))))

End Sub

Would that work like that?? I suck at VB.. RUN FROM V
 
F

Franz Verga

joelbeveridge said:
Should i do that in VB?
Click to expand...

No, the formulas I posted you have to write directly in cells and then copy
down across the rows...

But if you like, you could also use a macro...


--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy
 
J

joelbeveridge

Ill do the C2 one first.
C2: =IF(A2=1;"YES";IF(A2=2;"NO";IF(A2=3;"YES";IF(A2=4; "NO";""))))

So i go to Cell C2 then click on the fx tab - That then brings up a
menu, Called insert Function. So i then Pick the IF function, then
click ok, This brings up a Function Arguments box and then what??? So
dizzy...lol
 
J

joelbeveridge

Can you test that for me.
I entered

=IF(A2=1;"YES";IF(A2=2;"NO";IF(A2=3;"YES";IF(A2=4; "NO";"")))) into the
box and it gives me a error. Is there something im Missing
 
F

Franz Verga

joelbeveridge said:
Ill do the C2 one first.
C2: =IF(A2=1;"YES";IF(A2=2;"NO";IF(A2=3;"YES";IF(A2=4; "NO";""))))

So i go to Cell C2 then click on the fx tab - That then brings up a
menu, Called insert Function. So i then Pick the IF function, then
click ok, This brings up a Function Arguments box and then what??? So
dizzy...lol
Click to expand...


Just copy and past the formula from the post, then fix the values of YES or
NOT as for your needs...

--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy
 
F

Franz Verga

joelbeveridge said:
Can you test that for me.
I entered

=IF(A2=1;"YES";IF(A2=2;"NO";IF(A2=3;"YES";IF(A2=4; "NO";"")))) into
the box and it gives me a error. Is there something im Missing
Click to expand...


Sorry,

I wrote the formula directly in Outlook Express, so I wrote in the Italian
way, with ";" as argument separator instead of ",".

So, this should work:

=IF(A2=1,"YES",IF(A2=2,"NO",IF(A2=3,"YES",IF(A2=4,"NO",""))))

Just copy and past the formula from the post into Excel, then set the right
values for YES and NOT accordingly to your needs...

--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy
 
J

joelbeveridge

I entered the code into Cell C2 then Pressed Enter. Now it pops up a
message saying ERROR- "The Formula you type contains an error"

This was the Code i entered into Cell C-

=IF(A2=1;"YES";IF(A2=2;"NO";IF(A2=3;"YES";IF(A2=4; "NO";""))))

I dont care about the YES NO things at the moment. I would be happy if
it worked. You have been alot of help and i thank you so much, if its
not to much of a problem, could you try this and see if it works, its
not working for me at all.
 
Top