View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] michael@yang1.net is offline
external usenet poster
 
Posts: 6
Default embedding "ISERROR" function into an "IF" statement

I'm trying to add up a column of numbers and some of the cells have
#N/A or #DIV/0! which causes my summation to come up as an error as
well.

I'd like to keep my #N/A's in the cells and use the ISERROR function
and thought it should be embedded into an IF statement. Can any help
me do this?

Thanks

Mike