Thread: Nested Funtions
View Single Post
  #1   Report Post  
StephanieH
 
Posts: n/a
Default Nested Funtions

Is it possible to add one more argument to this formula?

=IF(COUNT(OFFSET($B138,-4,0,-6,1))=6,AVERAGE(OFFSET(C138,-4,0,-6,1)),"N/A")

I want to specify that if the result of the average is an error, then also
return "N/A"