software

Hi

In Cell A1 I have Possible Values from 1 to 6.
I want to have the following conditions in B1:

If a1=1 then quot;Rquot;,
If a1=2 then quot;Squot;,
If a1gt;2 then quot;Yesquot;

Thanks!--
Portuga
------------------------------------------------------------------------
Portuga's Profile: www.excelforum.com/member.php...foamp;userid=6385
View this thread: www.excelforum.com/showthread...hreadid=506815
You can use a nested IF formula in B1:

=IF(A1=1,quot;Rquot;,IF(A1=2,quot;Squot;,IF(A1gt;2,quot;Yesquot;,quot;quot;)))

or

=IF(A1=1,quot;Rquot;,IF(A1=2,quot;Squot;,quot;Yesquot;))

Not sure how AND comes into it.--
PipTT
------------------------------------------------------------------------
PipTT's Profile: www.excelforum.com/member.php...oamp;userid=30989
View this thread: www.excelforum.com/showthread...hreadid=506815=if(a1=1,quot;Rquot;,if(a1=2,quot;Squot;,quot;Yesquot;))

If you know you have 1-6 in A1.
Portuga wrote:
gt;
gt; Hi
gt;
gt; In Cell A1 I have Possible Values from 1 to 6.
gt; I want to have the following conditions in B1:
gt;
gt; If a1=1 then quot;Rquot;,
gt; If a1=2 then quot;Squot;,
gt; If a1gt;2 then quot;Yesquot;
gt;
gt; Thanks!
gt;
gt; --
gt; Portuga
gt; ------------------------------------------------------------------------
gt; Portuga's Profile: www.excelforum.com/member.php...foamp;userid=6385
gt; View this thread: www.excelforum.com/showthread...hreadid=506815

--

Dave Peterson


How about something like this:

B1: =CHOOSE(MIN( A1 1,4),quot;quot;,quot;rquot;,quot;squot;,quot;yesquot;)

Regards,
Ron--
Ron Coderre
------------------------------------------------------------------------
Ron Coderre's Profile: www.excelforum.com/member.php...oamp;userid=21419
View this thread: www.excelforum.com/showthread...hreadid=506815Put this formula in B1..........

=IF(A1=1,quot;Rquot;,IF(A1=2,quot;Squot;,IF(A1gt;2,quot;Yesquot;,quot;quot;)))

Vaya con Dios,
Chuck, CABG3
quot;Portugaquot; wrote:

gt;
gt; Hi
gt;
gt; In Cell A1 I have Possible Values from 1 to 6.
gt; I want to have the following conditions in B1:
gt;
gt; If a1=1 then quot;Rquot;,
gt; If a1=2 then quot;Squot;,
gt; If a1gt;2 then quot;Yesquot;
gt;
gt; Thanks!
gt;
gt;
gt; --
gt; Portuga
gt; ------------------------------------------------------------------------
gt; Portuga's Profile: www.excelforum.com/member.php...foamp;userid=6385
gt; View this thread: www.excelforum.com/showthread...hreadid=506815
gt;
gt;