Hi,
I am a teacher having trouble calculating grades when a grade is missing. I am using a gradebook template from microsoft's site. It keeps including the empty cell and counting it. The formula I'm using is this:
=(IF(SUM(F13:AF13),ROUND(SUM(F13:AF13)/$G$10,2),""))
I am using excel 97, and seem to have no luck getting the html maker to work with it. Can the formula ISEMPTY work with this? I am not too familiar with it...I would be glad to email the worksheet, since I can't get the html maker to work. Please let me know.
I am a teacher having trouble calculating grades when a grade is missing. I am using a gradebook template from microsoft's site. It keeps including the empty cell and counting it. The formula I'm using is this:
=(IF(SUM(F13:AF13),ROUND(SUM(F13:AF13)/$G$10,2),""))
I am using excel 97, and seem to have no luck getting the html maker to work with it. Can the formula ISEMPTY work with this? I am not too familiar with it...I would be glad to email the worksheet, since I can't get the html maker to work. Please let me know.