IF Function Blues
Posted by Geoff on December 20, 2000 9:23 PM
My students were given the option to make the lowest of
their four tests worth 15% and the final worth 25%. The
remaining 20% is based on homework and will not change.
I entered a "yes" for the option as 1, a "no" as a 0.
The last time I programmed anything was when BASIC was
the hottest thing around.
How do I write an IF statement that allows me to do
I have for a NO to the option:
But I'm stuck on how to weight the MIN (which will obviously shift for each student)
*.15, the Final*.25, and the other two test scores *.2