Multiple IF

A

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
)
 
B

BenjieLop

alen_re said:
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
)
Click to expand...

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.
 
A

alen_re

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

Thanks again...
 
Top