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

G

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.
 
B

BenjieLop

Karen said:
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.
Click to expand...

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.
 
R

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

sum values from range of cells if cells correcponding have the sam 15
convert a number to letter 2
Code works on sheet but not from code-to-sheet 2
Excel Add ^ to a row of cells containing letters 3
vlookup and if function 4
LOOKUP function different? 2
How do I Create a formula for greater or lesserthen 1
Lookup between two worksheets 8

Top