I need help with the IF Function that my professor is asking for

P13-4 (LO1) Payroll Tax Entries The following is a payroll sheet for Otis Imports for the month of September 2020. Selected information follows. 07 Unemployment compensation rate allowed by the state Unemployment compensation rate for the federal government Maximum wages for unemployment for federal and state governments Federal income tax rate for all employees FICA tax on employee and employer Maximum wages for FICA tax Employer and employee rate for an employee's excess wages Maximum wages per employee to avoid the excess wages charge 1.00% 0.80% $ 7,000 10% 7.65% $ 118,500 1.45% $ 118,500 Earnings to Name Aug 31 You must use cell references and formulas only in the yellow area. Hint: You may want to use an IF and AND statement to calculate FICA withholdings $ B.D. Williams D. Raye K. Baker F. Lopez A. Daniels B. Kingston Sept Income Tax Earnings Withholding $ 800 $ 80.00 700 $ 70.00 1,100 $ 110.00 1,900 $ 190.00 13,000 $ 1,300.00 16,000 $1,600.00 6,800 6,500 7,600 13,600 107,000 112,000 State Federal F.I.C.A. U.C. U.C. $ 61.20 $ 2.00 $ 1.60 $ 53.55 $ 5.00 $ 4.00 $ 84.15 $ (6.00) $ (4.80) $ 145.35 $ (66.00) $ (52.80) $ 994.50 $ (1,000.00) $ (800.00) $ 1,224.00 $ (1,050.00) $ (840.00) A A A A Start with IF(AND(cell from "Earnings to Aug 31" + cell from "Sept Earnings" > Maximum Wages for FICA tax, cell from "Earnings to Aug 31 "