Thread: How to return a number instead of true/false with an if function?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
kassie kassie is offline
external usenet poster
  
Posts: 515
Default How to return a number instead of true/false with an if function?
=IF(your condition,1,2)
eg =IF(A1=B1,1,2) will return a 1 if TRUE, and a 2 if FALSE

--
HTH

Kassie

Replace xxx with hotmail


"charles" wrote:

Please help
Reply With QuoteReply With Quote