View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Aditya Kumar Aditya Kumar is offline
external usenet poster
 
Posts: 1
Default Applying formula on formula

I have used IF formula on 10 grid values to get desried values.Further, on
these values i want to apply average formula.
Whenever i apply the average onto the grid values, it show DIV#0.
I have to maually write the IF derived values in new column and apply the
average formula onto them. Please help.