Formula Error
In the formula below I'm checking to see if a file exits. If it doesn't
then zero is suppose to be the value in the cell. If the file does exists
then it's suppose to supply the value from a cell in one of the worksheets of
the file.
I keep getting the "#REF" error which then throws the rest of my
calculations into a tail spin. What am I doing wrong here?
=IF(ISERROR("\\PANTHER\depts\TechnicalServices\Dai ly Status
Report\History\[IT Daily Status 061208.xls]"),0,
'\\PANTHER\depts\TechnicalServices\Daily Status Report\History\[IT Daily
Status 061208.xls]Executive Summary'!$C$30)
|