How do I set a formula if A1 is "a" then C1 is 3?
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" wrote in message
...
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.
|