conditional average formula

[louww]

Please help I cant seem to find a solution:

if f7:f8 contains false in any cell, return "not rated", if range contains numbers do average(f7:f8)

f7 and f8 have these formulas: =IF(C7="A",2,IF(C7="R",3,IF(C7="G",1)))

tried with no luck: =AVERAGE(IF(ISNUMBER(F7:F8),IF(F7:F8="FALSE","not rated")))

thanks!

[Zodeeak]

=IF(AND(ISNUMBER(F7),ISNUMBER(F8)),AVERAGE(F7:F8),"NOT RATED")

Hope that helps.

-Z

[louww]

WOW!, a solution in 2minutes, thanks!

[Jonmo1]

Try
=IF(COUNT(F7:F8)=2,AVERAGE(F7:F8),"Not Rated")

[louww]

Also works, thanks!