Nested if formula not working as intended

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

Hi,

Could you please upload your workbook?

Thanks

Hi thanks for the quick response:

Please find attached my workbook

Hi again,

As Martin said, you just went overboard with the brackets. Here is the corrected formula:

Formula:

Please Login or Register  to view this content.

Hope this helps

@Martin: yeah I know, but I was trying to keep the formula as close as possible to the original (except for the making it actually work part :P), as I find that this makes it easier for the original poster to comprehend

Awesome

Thank you so much, was worried that i would have to manually calc of my sheets.

No worries!

Please don't forget to mark this thread as solved, and please click on the * next to my post to say thanks