Hi People

I desperately require help on a formula that I have created.

The purpose of the formula is to find the biggest % of three tests, when the highest average has been found, the formula must then calculate the overall term average, weighting the highest average the most and the other two tests the least. All the tests and a practical average must = 100%


This is the formula i currently have:

=IF(AND(D2>F2,D2>H2),((D2*0.3)+(F2*0.15)+(H2*0.15)+(J2*0.4))),IF(AND(F2>D2,F2>H2),((F2*0.3)+(D2*0.15)+(H2*0.15)+(J2*0.4))),IF(AND(H2>D2,H2>F2),((H2*0.3)+(F2*0.15)+(D2*0.15)+(J2*0.4)),0)

This returns a #value error.

Any assistance will be welcomed

Thanks
DK