plz help asap and answer part 2,3, and 4!

Xercise Cycles Company sells exercise equipment to gyms on account. At year end, the following accounts receivable were uncollected. 2) Use the information above to complete the Aging of Accounts Receivable Schedule below. Create a formula for each age category, using the Excel IF and AND FUNCTIONS ( fx ) to determine where 1 customeramount belongs. 19 The IF statement mav include the followine areuments: <.>.>=