Some possibly useful excel functions and macros. save this function in a macro enables excel documnet (xlsm) and then you can use the formula =taxpayable(a1) and it will calculate the tax payable for that gross income. ATO Tax scales Australian … Continue reading ATO Tax calculations in Excel