Thread: How do I set a formula if A1 is "a" then C1 is 3?
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.newusers
JE McGimpsey
 
Posts: n/a
Default How do I set a formula if A1 is "a" then C1 is 3?
Put this in C1:

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

In article ,
"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 QuoteReply With Quote