Add formulas that look up the staff code in the spreadsheet you created in the previous step of this procedure and return the first name of the staff member and the appropriate hourly rate, ensuring that an hourly rate of SO is returned when no Staff ID is input. e. f. Add a formula to cells E11:E17 that will calculate the gross pay g. Add a formula to cells F11:F17 that will look up and calculate the tax amount payable h. Add a formula to cells G11:G17 that will calculate the net pay amount Add formulas that look up the staff code in the spreadsheet you created in the previous step of this procedure and return the first name of the staff member and the appropriate hourly rate, ensuring that an hourly rate of SO is returned when no Staff ID is input. e. f. Add a formula to cells E11:E17 that will calculate the gross pay g. Add a formula to cells F11:F17 that will look up and calculate the tax amount payable h. Add a formula to cells G11:G17 that will calculate the net pay amount