Thread: How do if create IF functions using text as the logical test?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
T. Valko T. Valko is offline
external usenet poster
  
Posts: 15,768
Default How do if create IF functions using text as the logical test?
A1 = Joe
B1 = 10

=IF(A1="Joe","Yes, A1 equals Joe","No, A1 does not equal Joe")

=IF(A1="Joe",B1*10,0)

=IF(AND(A1="Joe",B1=10),"Winner","Try again")

Biff

"nellybean" wrote in message
...



Reply With QuoteReply With Quote