Multiple IF
 

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
)


--
alen_re
------------------------------------------------------------------------
alen_re's Profile: http://www.excelforum.com/member.php...o&userid=28331
View this thread: http://www.excelforum.com/showthread...hreadid=503607

Multiple IF
 

alen_re Wrote:
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.


--
BenjieLop


------------------------------------------------------------------------
BenjieLop's Profile: http://www.excelforum.com/member.php...o&userid=11019
View this thread: http://www.excelforum.com/showthread...hreadid=503607

Multiple IF
 

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

Thanks again...


--
alen_re
------------------------------------------------------------------------
alen_re's Profile: http://www.excelforum.com/member.php...o&userid=28331
View this thread: http://www.excelforum.com/showthread...hreadid=503607

Multiple IF
 

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

Regards.


--
BenjieLop


------------------------------------------------------------------------
BenjieLop's Profile: http://www.excelforum.com/member.php...o&userid=11019
View this thread: http://www.excelforum.com/showthread...hreadid=503607