changing #value! to 0's

S

sik_chode

I have pulled down a function for a column.
the problem some of the values that this fn refers to are blank so i
get #value! message.
I want to give all cells with the #value! in them 0 so I can SUM the
column
how do i do that
 
R

Ron Coderre

There may be a few ways to resolve your issue. If you post an example
of the function that returns #VALUE!, it'll be easier to tailor a
solution for you.

Regards,
Ron
 
C

Cutter

Without further details, the simplest solution would be:

=IF(ISERR(your function),0,your function
 
Top