| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
how do I get excel to ignore blank cells in formulas
When I design a formula I will get the green upper left triangle indicating a
problem that the formula references a "blank" cell. At other times the same formula will register #Value error. I'm and old 123 user and this was never a problem, 123 just ignored the bland and assumed the null was a zero. Is there any way to get Excel to also assume a null is a zero? |
|
#2
|
|||
|
|||
|
Hi!
Not sure what you're asking but to get rid of those annoying colored triangles: ToolsOptionsError Checking Uncheck all of the Rules. Biff "rbignami" wrote in message ... When I design a formula I will get the green upper left triangle indicating a problem that the formula references a "blank" cell. At other times the same formula will register #Value error. I'm and old 123 user and this was never a problem, 123 just ignored the bland and assumed the null was a zero. Is there any way to get Excel to also assume a null is a zero? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do you ignore blank cells in formulas | Excel Discussion (Misc queries) | |||
| how do you ignore blank cells | Excel Discussion (Misc queries) | |||
| Adding contents of cells by clicking in Excel 2002 | Excel Discussion (Misc queries) | |||
| No Smart Tag help: just a blank "MS Excel Help" window - Excel 2003 | Excel Discussion (Misc queries) | |||
| How do I password protect cells in a spreadsheet created in Excel | Excel Worksheet Functions | |||
Linear Mode
