=AVERAGE( VW1:VW2)> 60%

anyone an Microsoft Excell wizard?

I want to set up a formula that will average the manually input percentages of 2 separate and potentially different cells (easy) --heres the tricky part , I want to assign percentage value importances e.g.: cell number one will have a 60% percentage wieght in the average and cell number two will have a 40% percentage wieght in the average. cell number 3 will be the formula cell and will automatically calc the avg however based on the wieghts.

i could tell you that this was VW related.....but i would not be telling the truth.

if someone helps me with this i promise to never post non vw stuff again......im just stumped and i can find anything to help.

Devin