Thread
:
How do I set a formula if A1 is "a" then C1 is 3?
View Single Post
#
2
Posted to microsoft.public.excel.newusers
Search33
Posts: n/a
How do I set a formula if A1 is "a" then C1 is 3?
=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.
Reply With Quote