View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
MCheru MCheru is offline
external usenet poster
 
Posts: 70
Default Eliminating #DIV/O!

I have this formula =SUM(AVERAGE(N4:N200)). Right now #DIV/O! appears if
N4:N200 does not have any data to report. Is it possible to modify this
formula so that the cell the formula is in reports a zero 0 if it does not
have any data to report?