S
Snowshoe Bob
Using 12.2.4. I have a gradebook in which a final mark is calculated using
the best five of six grades or, for some individuals, the best four of six
(for these one grade will be an empty cell). Doing the best five of six is
easy (add them up and subtract the minimum), the best four of six I haven't
been able to figure out (at least not simply). There is a cell that
indicates whether to calculate the best 5 or the best 4, but to use the same
formula for the latter would seem to require a function that takes the two
minimum (one of which is always an empty cell) and I cannot find such a
function. Any ideas all?
the best five of six grades or, for some individuals, the best four of six
(for these one grade will be an empty cell). Doing the best five of six is
easy (add them up and subtract the minimum), the best four of six I haven't
been able to figure out (at least not simply). There is a cell that
indicates whether to calculate the best 5 or the best 4, but to use the same
formula for the latter would seem to require a function that takes the two
minimum (one of which is always an empty cell) and I cannot find such a
function. Any ideas all?