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? |
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? |
All times are GMT +1. The time now is 07:41 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com