changing #value! to 0's

  • Thread starter Thread starter sik_chode
  • Start date Start date
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
 
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
 
Without further details, the simplest solution would be:

=IF(ISERR(your function),0,your function
 
You must log in or register to reply here.

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

#value error for sumproduct using RIGHT cmd 0
Excel formula, sum the value cell and if empty cell left blank 0
want to track time while paste value in multiple column of same roe 1
Sum values in one row dependent on a value in a different row 4
Blank Cells vs. Zero Values 2
SUM formula results returns 0 value 7
conditional format if cell value 0 pattern red value blank nothing 1
Sum Values from different column 1

Back
Top