Some possibly useful excel functions and macros
Australian Tax department “sliding” scales calculation
Function taxpayable(income) 'Stop If income < 6000 Then taxpayable = 0 ElseIf income < 35000 Then taxpayable = 0.15 * (income - 6000) ElseIf income < 80000 Then taxpayable = 4350 + 0.3 * (income - 35000) ElseIf income < 180000 Then taxpayable = 17850 + 0.38 * (income - 80000) Else taxpayable = 55850 + 0.45 * (income - 180000) End If End Function
="Login to the ftp server " & H11 & "." & I11 &" with the username " &B11&" and password "&E11&" and open the folder "&F11 ="ftp://"&B11&":"&E11&"@"&H11&"."&I11&"/"&G11 ="Inside the office you can access this area by going to "&J11