View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
damorrison
 
Posts: n/a
Default How to correctly write a cross-sheet "IF" formula in Excel

=IF(FAIR!M6="","",FAIR!A6,IF(FAIR!N6="","",FAIR!A6 ))
try this to start