Apply the employee Medicare rate of 1.45% to all Medicare wages. Unlike Social Security, this ordinary Medicare calculation has no annual wage cap.
Read the case before entering a formula. The workbook separates input amounts from the result so a reviewer can trace your calculation. Use references rather than typing the displayed total. A hidden copy changes the inputs and checks that your approach still works. Compare the result with the stated period and wage base, then examine any cap or zero balance. A blank cell and a zero result mean different things. Keep the sign on reconciliation differences so another reviewer can tell whether the register is higher or lower.
Apply the employee Medicare rate of 1.45% to all Medicare wages. Unlike Social Security, this ordinary Medicare calculation has no annual wage cap.