Multiple IF

[alen_re]

Hi everyone...

I have a question !

Sheet1:
A1 (input)

A2, A3, A4, A5
(here I need to get a number 1 depending on input in A1. If I put in A1 :
G I will get number 1 in A2
V I will get number 1 in A3
VP I will get number 1 in A4
C I will get number 1 in A5
)

[BenjieLop]

Hi everyone...

I have a question !

Sheet1:
A1 (input)

A2, A3, A4, A5
(here I need to get a number 1 depending on input in A1. If I put in A1 :
G I will get number 1 in A2
V I will get number 1 in A3
VP I will get number 1 in A4
C I will get number 1 in A5
)

See if the following will work for you:

In Cell A2: =if(A1="G",1,"")
In Cell A3: =if(A1="V",1,"")
In Cell A4: =if(A1="VP",1,"")
In Cell A5: =if(A1="C",1,"")

Regards.

[alen_re]

Thanks a lot.. This is answer to my question..
Simple.. but when you don't know..

Thanks again...

[BenjieLop]

You are welcome ... just glad I can help.

Regards.