Issue creating an average based on cells with formulas

[lukertomlinson99]

Hi,

If I have a cell that uses a formula to work out a result and that then pumps out a value. Why when I am trying to create a average for those generated numbers in a column does it not work and pumps out #DIV/0! rather than the average of the generated numbers. I have a feeling it is due to the cells being based on a formula but surely there is a work around.

Example from data:
=IF($A$5="C1 - Mid (F)",(IF(E5>='base info KS4'!$C$7,"5",IF(E5>='base info KS4'!$C$6,"4",IF(E5>='base info KS4'!$C$5,"3",IF(E5>='base info KS4'!$C$4,"2",IF(E5>='base info KS4'!$C$3,"1",IF(E5>='base info KS4'!$C$2,"0"))))))))
This pumps out for example the number 5 then the next is 4 and 3.
When I average them =AVERAGE(F5:F8) it doesn't work?

 

[offthelip]

It is because you are writing characters not numbers with your equation.
Change "5" to 5 , "4" to 4 , "3" to 3 etc