Note: You have to save file type as Excel Macro-Enabled Wordbook(.xlsm) or Excel 97-2003 Workbook (.xls) format in order to have a function working.Īlso in Excel 2010 version, you need to check on “Enable all macros” on Excel Options>Trust Center>Macro Setting to enable Macro or VBA function. So if homework is worth 25 of your grade, the weight would be 0.25.