software

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: www.excelforum.com/member.php...oamp;userid=28331
View this thread: www.excelforum.com/showthread...hreadid=503607
alen_re Wrote:
gt; Hi everyone...
gt;
gt; I have a question !
gt;
gt; Sheet1:
gt; A1 (input)
gt;
gt; A2, A3, A4, A5
gt; (here I need to get a number 1 depending on input in A1. If I put in A1
gt; :
gt; *G* I will get number 1 in A2
gt; *V* I will get number 1 in A3
gt; *VP* I will get number 1 in A4
gt; *C* I will get number 1 in A5
gt; )

See if the following will work for you:

In Cell A2: =if(A1=quot;Gquot;,1,quot;quot;)
In Cell A3: =if(A1=quot;Vquot;,1,quot;quot;)
In Cell A4: =if(A1=quot;VPquot;,1,quot;quot;)
In Cell A5: =if(A1=quot;Cquot;,1,quot;quot;)

Regards.--
BenjieLop------------------------------------------------------------------------
BenjieLop's Profile: www.excelforum.com/member.php...oamp;userid=11019
View this thread: www.excelforum.com/showthread...hreadid=503607
Thanks a lot.. This is answer to my question..
Simple.. but when you don't know..

Thanks again...--
alen_re
------------------------------------------------------------------------
alen_re's Profile: www.excelforum.com/member.php...oamp;userid=28331
View this thread: www.excelforum.com/showthread...hreadid=503607
You are welcome ... just glad I can help.

Regards.--
BenjieLop------------------------------------------------------------------------
BenjieLop's Profile: www.excelforum.com/member.php...oamp;userid=11019
View this thread: www.excelforum.com/showthread...hreadid=503607