changing #value! to 0's
 

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


--
sik_chode
------------------------------------------------------------------------
sik_chode's Profile: http://www.excelforum.com/member.php...o&userid=26007
View this thread: http://www.excelforum.com/showthread...hreadid=393666

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


--
Ron Coderre
------------------------------------------------------------------------
Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419
View this thread: http://www.excelforum.com/showthread...hreadid=393666

Without further details, the simplest solution would be:

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


--
Cutter
------------------------------------------------------------------------
Cutter's Profile: http://www.excelforum.com/member.php...fo&userid=9848
View this thread: http://www.excelforum.com/showthread...hreadid=393666