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

[Guest]

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.

 

[Guest]

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

 

[JE McGimpsey]

Put this in C1:

=IF(A1="a",3,IF(A1="b","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.

 

[Guest]

Thank you so much!!

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

 

[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!
=====================================================

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.