Nested if formula not working as intended

[Reibie]

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 how my cells are structured

Class Test (40) 31/07/13	Class Test %	Class Test (40) 29/08/13	Class Test %	Class Test (35) 09/09/13	Class Test %	Physics Prac: Electricity (60) 27/05/13	Physics Prac: Electricity %	Term Calculated 100 %
25	71	30	75	33	94	50	83	#VALUE!

<tbody>
</tbody>

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

 

[TheCman81]

Not 100% sure in what you're asking but does this work

=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)))

 

[Reibie]

It did thanks a mil