Function Yields #DIV/0!

T

Tim Nichols

How can I get one cell to return zero instead of #DIV/0! (from a function)
so all my cells will add up? I need the function in there because based on
other variables, sometimes it wouldn't return #DIV/0!?

I tried the if function - IF(...="#DIV/0!" then 0,...) - but that didn't
work.
 

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

How do I make #DIV/0! error message go away? 2
Newbie Help - IF Yes No Function 0
How to render HTML inside a Powerpoint slide through VBA 0
#DIV/0! error with DAVERAGE Function 5
Taking Average ignoring #DIV/0! in the range... 1
Need to average data if in cells, but ignore blank cells. 4
Macro to get rid of #DIV/0! 2
Conditional format for #DIV/0 2

Top