Choose 2 of 6 optional units for grade - formula question
I'm not sure how units, assignments, marks differ in meaning, but it
seems you'd make a table on another sheet that holds the different
values for the units, then use vlookup to pull the correct amount.
|