Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Leave a cell COMPLETELY blank if there is an error
My question is similar to many others in this discussion group, but I have
searched pretty thoroughly and not found the answer to my exact question... What I want to do is to leave a cell completely blank if the result of an ISERROR test (shown below) is true. I need that cell to be completely blank, because in another cell I have an INDIRECT formula that relies on the COUNTA function that refers to this first cell. If the IF(ISERROR...) formula deposits a "" in a cell, it will be counted in the COUNTA formula, and INDIRECT will pull the (nonexistent) value from this cell. (This formula is on a sheet named calc) =IF(ISERROR((raw!K285),"",(raw!J285-(raw!K285/raw!K273-1)*100)) =INDIRECT(CONCATENATE("'calc'!f",COUNTA(calc!$F:$F )+23)) Is there a way to do this? Thank you! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
To leave the cell Blank | Excel Worksheet Functions | |||
Leave cell blank | Excel Worksheet Functions | |||
Leave Cell Blank if value is an error, below 0 or above 80 | Excel Discussion (Misc queries) | |||
leave a cell blank | Excel Worksheet Functions | |||
To Leave Cell blank Please | Excel Worksheet Functions |