Thread: How to correctly write a cross-sheet "IF" formula in Excel
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jay
 
Posts: n/a
Default How to correctly write a cross-sheet "IF" formula in Excel
This results in an error, "too many arguments".

Do you have any more ideas?

"damorrison" wrote:

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


Reply With QuoteReply With Quote