Thread: Match function: error due to format?
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
isabelle isabelle is offline
external usenet poster
  
Posts: 587
Default Match function: error due to format?
hi,

in cell A1

=IF(...RIGHT...CELL...)*1

or

=--IF(...RIGHT...CELL...)

--
isabelle

Reply With QuoteReply With Quote