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


--
joelbeveridge
------------------------------------------------------------------------
joelbeveridge's Profile: http://www.excelforum.com/member.php...o&userid=37045
View this thread: http://www.excelforum.com/showthread...hreadid=567717

joelbeveridge wrote:
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

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

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 VB


--
joelbeveridge
------------------------------------------------------------------------
joelbeveridge's Profile: http://www.excelforum.com/member.php...o&userid=37045
View this thread: http://www.excelforum.com/showthread...hreadid=567717

joelbeveridge wrote:
Should i do that in VB?

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

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


--
joelbeveridge
------------------------------------------------------------------------
joelbeveridge's Profile: http://www.excelforum.com/member.php...o&userid=37045
View this thread: http://www.excelforum.com/showthread...hreadid=567717

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


--
joelbeveridge
------------------------------------------------------------------------
joelbeveridge's Profile: http://www.excelforum.com/member.php...o&userid=37045
View this thread: http://www.excelforum.com/showthread...hreadid=567717

joelbeveridge wrote:
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


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

joelbeveridge wrote:
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


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

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.


--
joelbeveridge
------------------------------------------------------------------------
joelbeveridge's Profile: http://www.excelforum.com/member.php...o&userid=37045
View this thread: http://www.excelforum.com/showthread...hreadid=567717