| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find value in array | Excel Worksheet Functions | |||
| Formula Error | New Users to Excel | |||
| Formula Recalculation Error | Excel Worksheet Functions | |||
| Let me save/close EXCEL if a formula I put in has an error in it | Setting up and Configuration of Excel | |||
| I get error with "ROWS" in the formula - nested formula question | Excel Worksheet Functions | |||
Threaded Mode
