How do I set a formula if A1 is "a" then C1 is 3?

[Karen]

I'm wanting to set a formula so that if cell A1 is "a" then C1 would be 3 and
if A1 is "b" then C1 would be 5.

[BenjieLop]

I'm wanting to set a formula so that if cell A1 is "a" then C1 would be 3 and
if A1 is "b" then C1 would be 5.

Enter this formula in Cell C1:

=if(A1="a",3,if(A1="b",5,""))

NOTE: for any other entry in Cell A1, Cell C1 will be blank.

Regards.

[Search33]

=IF(A1="a",3,IF(A1="b",5,"Whatever you want if neither are true"))

"Karen" wrote:

> I'm wanting to set a formula so that if cell A1 is "a" then C1 would be 3 and
> if A1 is "b" then C1 would be 5.

[JE McGimpsey]

Put this in C1:

=IF(A1="a",3,IF(A1="b","5",""))

In article <8142453F-B774-4902-9E16-221AB3714308@microsoft.com>,
"Karen" <Karen@discussions.microsoft.com> wrote:

> I'm wanting to set a formula so that if cell A1 is "a" then C1 would be 3 and
> if A1 is "b" then C1 would be 5.

[Karen]

Thank you so much!!

"Search33" wrote:

> =IF(A1="a",3,IF(A1="b",5,"Whatever you want if neither are true"))
>
> "Karen" wrote:
>
> > I'm wanting to set a formula so that if cell A1 is "a" then C1 would be 3 and
> > if A1 is "b" then C1 would be 5.

[RagDyeR]

To return a zero when criteria is not met, try:

=(A1="A")*3+(A1="B")*5

--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

"Karen" <Karen@discussions.microsoft.com> wrote in message
news:8142453F-B774-4902-9E16-221AB3714308@microsoft.com...
I'm wanting to set a formula so that if cell A1 is "a" then C1 would be 3
and
if A1 is "b" then C1 would be 5.