View Full Version : Help me with excel please
09-16-2008, 07:38 AM
I made a grade sheet for my mother (teacher) and I got all of the formulas figured out fine except for one. I want the average to not be able to go over 100 (throws overall grade off if individual subject goes over 100). I thought I could do something like:
But I just cant get it to work!
09-16-2008, 08:15 AM
Try copy pasting that.
I think you just messed up the parentheses.
09-16-2008, 05:59 PM
I did eventually get it by using the built in formula constructor (You were right, a matter of parentheses). Of course then she tells me they gave her some software to do it for her! booo.
09-16-2008, 07:49 PM
another way to do it is
but lisakki is right, you messed up the parentheses.
vBulletin® v3.8.7, Copyright ©2000-2013, vBulletin Solutions, Inc.