Thread: If statement
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Peo Sjoblom Peo Sjoblom is offline
external usenet poster
  
Posts: 3,268
Default If statement
=IF(A1=0,"",CHOOSE(A1,etc


--


Regards,


Peo Sjoblom


wrote in message
...
Thanks, that worked.

What do I do if I have a 0 in my 1st column since it seems that the
choose function starts at 1?


Reply With QuoteReply With Quote