Could you please help me simplify this formula by reducing the number of times the worksheet reference needs to be repeated? Thank you!
=IF(AND(ISNUMBER('Macintosh HD:Users:name:Desktop:2010 points:[2010 MREC Template.xls]results'!$O$5),ISTEXT('Macintosh HD:Users:name:Desktop:2010 points:[2010 MREC Template.xls]results'!$E$5),ISTEXT('Macintosh HD:Users:name:Desktop:2010 points:[2010 MREC Template.xls]results'!$C$5)),'Macintosh HD:Users:name:Desktop:2010 points:[2010 MREC Template.xls]results'!O5,FALSE
Bookmarks