Hi,
I am using the following formula's for a weighted grade sheet. The Q8 cell is the number of months with data. The D8 cell is Month 1 Weight. The F8 cell is Month 2 Weight. The H8 cell is Month 3 Weight.
Month 1 Weight = IF(Q8=1,D8*1,D8*((1/Q8)*(1.5)))
Month 2 Weight = F8*((1/Q8)*(1.5-IF(Q8=2,1,IF(Q8=3,0.5,0))))
Month 3 Weight = H8*((1/Q8)*(1.5-1))
This works fine, but when I try to convert the formula to except 6 months of data it does not work. I attached a sample spreadsheet which has the expected results next to the Overall Grade.
Any suggestions?
Many thanks in advance.
~Don
Bookmarks