| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I get excel to ignore formula in dependant cells...
Hi Ted
See answer posted to your earlier thread. Regards Roger Govier Ted wrote: Hi, I need to run a formula on cells which themselves contain formula. The second formula is subtracting, say, A1 from B1. The problem is when there are no answers in the dependant cells (A1, B1 or both) €“ it, as expected just gives a value of #VALUE! How can I get excel to ignore the formula and return the value of zero, when no data/numbers have been generated by the original/initial formula/dependant cells?? Thanks in advance. Ted. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| quick way to copy-paste a formula linked to cells in another file | Excel Worksheet Functions | |||
| copy & paste spreadsheet cells from excel to outlook to excel | Excel Discussion (Misc queries) | |||
| Ignore error msgs in formula references | Excel Discussion (Misc queries) | |||
| How do I ignore cells in Excel? | Excel Worksheet Functions | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
Hybrid Mode
