Some problems with the weighted average

No replies
Wed, 26 Jan 2011 - 3:02 PM
Gianluca
Offline
Last seen: 5 years 9 weeks ago
Title: ★
Joined: 22 Oct 2010
Posts: 1

Hi guys,

I have some doubts about how calculate the weighted average.

As you can see in this picture, I want to calculate the weighted average of my university marks.

http://img689.imageshack.us/i/screenshotoaf.png/

I think the formula that I wrote in G17 cell is correct only if I have all the marks in the interval G2:G16, but as you can imagine, I have some exams that I don't have already passed.

How I have to modify the formula for calculate the weighted average? and how I can say to Calc that a "30 e Lode" is a 33?

Best regards,

Gianluca Rossi


Ps: sorry for my bad English, I'm not a native English speaker :(

Pps: thank you for your job guys, VIVA LIBREOFFICE!!

Top