Function: SUM: Formula: Subtract, Multiply: Cell Referencing

Using Excel to Create an Aging Schedule and Record Credit Losses

PROBLEM

Mendez Imports prepared the following aging schedule at December $31$

$\backslash$table$[[\backslash$table$[[$Number of$],[$Days$],[$Dutstanding$]],\backslash$table$[[$Accounts$],[$Receivable$]],\backslash$table$[[$Estimated$],[$Percentage$],[$Uncollectible$]]],[0-30$ days,$$368,000,1\%$