The help file says (I believe) that IFs can be nested 64 deep.
That is: =IF(G5>0,average(G5:G9),IF(G6>0,average(G6:G10),.. ... etc.

I currently have such a formula/function in my spreadsheet which contains 7 IFs and it works OK. But if I try to add an additional "IF", I get an error.

Any ideas? I can send/email an example sheet if need be.

Thanks for any help,

Jim