sailor_taylor
New Member
- Joined
- Mar 15, 2009
- Messages
- 20
I am looking for a formula which will tell me the "missing grade (F1)" that will, when averaged with at least two other numbers (B1 - E1), will result in my goal of the number in cell A1.
Summary:
Cell A1 is the averaged grade I want to achieve
Cells B1, C1 (and sometimes D1 and E1) are known grades
Cell F1 is the number, when averaged with B1 - E1, will give me the grade in cell A1
This ugly formula works when there are two (and only two) known grades:
=(A1*3)-(B1+C1)
Any advice will be greatly appreciated.
Summary:
Cell A1 is the averaged grade I want to achieve
Cells B1, C1 (and sometimes D1 and E1) are known grades
Cell F1 is the number, when averaged with B1 - E1, will give me the grade in cell A1
This ugly formula works when there are two (and only two) known grades:
=(A1*3)-(B1+C1)
Any advice will be greatly appreciated.