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