how do I get excel to ignore blank cells in formulas

G

Guest

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?
 
B

Biff

Hi!

Not sure what you're asking but to get rid of those annoying colored
triangles:

Tools>Options>Error Checking

Uncheck all of the Rules.

Biff
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sumif problem with zero value and blank cells 6
how to make a formula ignore blank cells 6
# Value error and how to ignore blank cells 2
how do I skip blank cells when writing formulas 1
How do I default blank cells to "0"? 3
How do I ignore cell values of zero? 2
How can I get excel to ignore formula in dependant cells... 4
Ignore blank cells when calculating date for If, Then function 2

Top