I need formulas for B-E, as you can see i have already tried what should be the correct formula for v-lookup. this honestly shouldnt be this hard, i know excel and i would use the if function but i would have to do that for each value.

b. Create a formula in column G that attaches the correct label to each invoice (e.g., if the invoice is 030 days old, the label should be "0-30"; if it is 31-60 days old, the label should be "31-60", etc.) according to the table in the upper right corner of the spreadsheet. c. Create a pivot table that shows the sum, count, and average values for each of the four categories of accounts receivable. d. Create a pivot table that shows total amounts and count of invoices by both category (e.g., 0-30, 31-60, etc.) and region (East, West, North, South). e. Modify the pivot table in step d to be able to filter the results by salesperson. Suggestions: First, use a formula to calculate the age of AR (Column F). It is the difference between the invoice date and the aging date. Second, create a formula to classify each invoice under the different categories of days outstanding such as 0-30, 31-60, etc. You can use an "If" statement or a "VLookup". There may be other ways to do this as well. (Column G) Third, insert pivot tables to answer parts c,d, and e