Thread: How to correctly write a cross-sheet "IF" formula in Excel
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max
 
Posts: n/a
Default How to correctly write a cross-sheet "IF" formula in Excel
Inferring from your orig post:
=IF(FAIR!M6"","",FAIR!A6,IF(FAIR!N6"","",FAIR!A6))

Not very sure, but maybe you're looking for:
=IF(OR(Fair!M6="",Fair!N6=""),Fair!A6,"")
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--


Reply With QuoteReply With Quote