Function Yields #DIV/0!

  • Thread starter Thread starter Tim Nichols
  • Start date Start date
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.
 
Back
Top