| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
identical formula returns #VALUE! error
Hi,
I have two identical formaulas in a worksheet that refer to the same cells in other worksheets. The first one works properly and returns the correct response. The second one will only return the correct response when the cells are blank otherwise it returns a #VALUE! error even though the first formula returns the correct response. Has anyone experienced this before? Both formula cells are formatted as General. Here is the formula entered in two different cells: =IF('6. Micro Controller & Panel'!A12=0,"NOT STARTED",IF('6. Micro Controller & Panel'!A12='2. Access Control System (ACS)'!J31:J33,"COMPLETED","VERIFY # ENTERED IN 2.06")) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| INDEX formula returns #REF! error for ranges larger than two cells | Excel Worksheet Functions | |||
| Array Formula returns error but only for specific columns | Excel Discussion (Misc queries) | |||
| Sumproduct returns value error when ref is formula | Excel Discussion (Misc queries) | |||
| Formula to sum every 4th cell returns #DIV/0! error in some column | Excel Worksheet Functions | |||
| formula returns error in version 2003 only | Excel Worksheet Functions | |||
Threaded Mode
