Need help understanding how to correct my formulas based off the feedback to the instructions provided. I will list all the formulas I used that were marked as "incorrect. Please let me know if more information is needed.

*FORMULAS I CURRENTLY HAVE THAT NEED I NEED HELP CORRECTING BASED ON FEEDBACK IN RED TEXT*

2)

Formula in B3 =DATE(2021,6,1)

Formula in F6 =IF(F6>30,$B$3-E6,0)

6)

Formula in J6 =IF(OR(I6="A",H6=FALSE),TRUE,FALSE)

10)

Formula in c6 =IFERROR(B6/B$11,"ERROR DIVIDE BY 0")

Formula in c11 =IFERROR(B6/B$11,"ERROR DIVIDE BY 0")

0/10 Create a formula using a function. Copy a formula into a range. 6. Clients are eligible for a discount if they have a rating of "A" or do not require an email reminder. Provide this information for Brett as follows: a. In cell J6, insert a formula using the OR function that returns TRUE if the rating cell 16) equals "A" or the email reminder (cell H6) equals FALSE. b. Use the Fill Handle to fill the range 37:J15 with the formula in cell J6, filling the range without formatting. X Create a formula using a function. In the Client Invoices worksheet, the formula in cell J6 has not been entered correctly. X Copy a formula into a range. In the Client Invoices worksheet, cell J6 contains an incorrect formula. 7. Brett likes to keep track of the total number of current invoices he has sent to clients. In cell B17, enter a formula using the COUNT function that counts the invoice numbers (the range A6:415). 10/10 10/10 10/10 0/10 Create a formula using a function. 8. Brett also likes to keep track of the approximate amount he has billed clients. In cell B18, enter a formula using the ROUND and SUM functions that totals the invoice amounts (the range D6:D15) and rounds the result to 0 decimal places. Create a formula using a function. 9. Go to the Quarter 3 Sales worksheet. Apply the Accounting number format to the sales amounts (range B6:B11) to indicate they are dollar amounts. Change the number format. 10. Brett wants to calculate the percentage of each category of insurance contributed to his total sales. Because he also wants to avoid a divide by zero error in the calculation, he has already entered the IFERROR function. Complete the formula as follows: a. In cell C6, before the comma in the FERROR function, create a formula without using a function that divides the amount of automobile insurance sales (cellB6) by the total sales (cell B11). b. Use an absolute reference to cell B11 in the formula. c. Use the Fill Handle to fill the range C7.C10 with the formula in cell C6. X Create a formula using a function. In the Quarter 3 Sales worksheet, the formula in cell C6 should contain an absolute reference to cell B11. X Copy a formula into a range. In the Quarter 3 Sales worksheet, cell C6 contains an incorrect formula. 10/10 1. Brett Thao is an insurance agent for the Great Midwestern Insurance in Milwaukee, Wisconsin. He is analyzing the invoices he has sent clients and the sales he generated in the third quarter of the year. He asks you to help him complete the analysis. Go to the Client Invoices worksheet. In cell B3, insert a formula using the DATE function to display the current date as 6/1/2021 (m/d/yyyy) so that Brett can use the date in calculations. [Mac Hint: The date will display using the format m/d/yy.] Create a formula using a function. 2. In column F, Brett wants to display the age of the invoice, which is the number of days between the current date and the invoice date. Provide this information as follows: a. In cell F6, insert a formula without using a function that subtracts the invoice date (cellB6) from the current date (cell B3). b. Use an absolute reference to cell B3 in the formula. c. Use the Fill Handle to fill the range F7:F15 with the formula in cell F6, filling the range without formatting. 0/10 X Create a formula without using a function. In the Client Invoices worksheet, the formula in cell F6 should subtract the value in cell B6 from the value in cell B3. X Copy a formula into a range. In the Client Invoices worksheet, cell F6 contains an incorrect formula. 3. In column G, Brett wants to calculate the number of days the invoice is overdue. If the age of the invoice is greater than 30 days, it is overdue. Calculate the days overdue as follows: a. In cell G6, insert a formula using the IF function that tests whether the age of the invoice (cell F6) is greater than 30. b. If the age of the invoice is greater than 30, subtract the due date (cell E6) from the current date (cell B3). c. If the age of the invoice is less than or equal to 30, display 0 to show that the invoice is not overdue. d. Use an absolute reference to cell B3 in the formula. e. Use the Fill Handle to fill the range G7: 615 with the formula in cell G6, filling the range without formatting. 10/10 10/10 Create a formula using a function. Copy a formula into a range. 4. Brett sends an email reminder to clients with overdue invoices for amounts more than $1,000. Provide a quick way to identify those clients as follows: a. In cell H6, insert a formula using the AND function that returns TRUE if the number of days overdue (cell G6) is greater than 0 and if the invoice amount (cell D6) is greater than 1000. b. Use the Fill Handle to fill the range H7:H15 with the formula in cell H6, filling the range without formatting. AutoSave OFF A @@ 9 Huc IL_EX19_3a_MeghanCorrigan_2 Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Calibri (Body) 11 Insert v V 20 ab Wrap Text General 28-O Delete Paste B I U QvA V E == 333 Merge & Center v $ v % V , Co-29 Conditional Format Cell Formatting as Table Styles E Sort & Filter Format v Find & Select Sensitivity Analyze Data MAX x fx =DAYS(B3$B$3,B6) X $) DAYS(end_date, start date) A B D E F G H I 1 1 Great Midwestern Insurance Client Accounts 2 6/1/21 Ratin Days Overdue 48 48 30 30 Invoice Date Account Name 3/15/21 Miguel Grazia 3/15/21 Melissa Sullivan 4/2/21 Ruth Hahn 4/2/21 Troy Danz 5/1/21 Jeong Pen 4/15/21 Tom Marlowe 5/1/21 Brent Pederson 4/15/21 Charles Korato 5/15/21 Alex Munoz 5/15/21 Anna Napier Amount 1,425.15 907.88 915.65 1,023.33 824.80 1,095.67 1,045.50 1,235.33 1,127.75 804.67 $ $ $ $ $ $ $ $ $ $ 3 Current date: 3 4 5 Invoice Number 6 1894 7 1907 8 1988 9 1997 10 2003 11 2004 12 2014 13 2021 14 2045 15 2053 16 17 Total invoices: 18 Total amount: 19 20 21 1 Client Invoices Due Date Age of Invoice 4/14/21 =DAYS(B3$B$3,B6) 4/14/21 78 5/2/21 60 5/2/21 60 5/31/21 31 5/15/21 47 5/31/21 31 5/15/21 47 6/14/21 17 6/14/21 17 Email TRUE FALSE FALSE TRUE FALSE TRUE TRUE TRUE FALSE FALSE > 00 00 00 00 noon 17 B 1 17 0 A 0 A 10 $ 10,406.00 Documentation Client Invoices Quarter 3 Sales + Point 191% AutoSave OFF A @@ 9 Huc IL_EX19_3a_MeghanCorrigan_2 Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Calibri (Body) 11 20 ab Wrap Text General Insert v QvA ( 28-Or Delete Paste BIU E V Merge & Center v $ v % , Sort & O O V Conditional Format Cell Formatting as Table Styles Sensitivity Format Find & Select Filter Analyze Data MAX x =( x fx =DAYS(B3$B$3,B6) B D E F G H T J 2 Client Accounts 3: 6/1/21 uw N 4 5 ber Age of Invoice Days Overdue 48 Email TRUE FALSE Rating 64 no 48 C 7 7 8 8 78 60 30 DAYS(end_date, start date) TRUE 60 30 C Invoice Date Account Name 3/15/21 Miguel Grazia 3/15/21 Melissa Sullivan 4/2/21 Ruth Hahn 4/2/21 Troy Danz 5/1/21 Jeong Pen 4/15/21 Tom Marlowe 5/1/21 Brent Pederson 4/15/21 Charles Korato 5/15/21 Alex Munoz 5/15/21 Anna Napier Amount 1,425.15 907.88 915.65 1,023.33 824.80 1,095.67 1,045.50 1,235.33 1,127.75 804.67 1 Client Invoices Due Date 4/14/21 4/14/21 5/2/21 5/2/21 5/31/21 5/15/21 5/31/21 5/15/21 6/14/21 6/14/21 $ $ $ $ $ $ $ $ $ $ B 31 47 17 Discour FALSE TRUE TRUE FALSE TRUE FALSE FALSE FALSE TRUE TRUE B 31 1 B FALSE TRUE TRUE TRUE FALSE FALSE 97 10 3 11 4 12 4 13 1 1 14 5 15 3 16 17 s: 18 t: 19 20 47 17 B 17 0 A 17 0 A 10 $ 10,406.00 21 22 Documentation Client Invoices Quarter 3 Sales + Point 191% C6 fx =IFERROR(B6/B$11, "ERROR DIVIDE BY 0") B C D E F G 1 Great Midwestern Insurance Sales Summary % of Total 2 3 4 5 Category 6 Automobile 7 Casualty 8 Homeowners 9 Personal property 10 Renters 11 12 13 Quarter 3 Amount $ 10,453.25 $ 8,755.67 $ 9,877.35 $ 8,034.80 $ 7,523.50 Total $ 44,644.57 23% 20% 22% 18% 17% 23% 0/10 Create a formula using a function. Copy a formula into a range. 6. Clients are eligible for a discount if they have a rating of "A" or do not require an email reminder. Provide this information for Brett as follows: a. In cell J6, insert a formula using the OR function that returns TRUE if the rating cell 16) equals "A" or the email reminder (cell H6) equals FALSE. b. Use the Fill Handle to fill the range 37:J15 with the formula in cell J6, filling the range without formatting. X Create a formula using a function. In the Client Invoices worksheet, the formula in cell J6 has not been entered correctly. X Copy a formula into a range. In the Client Invoices worksheet, cell J6 contains an incorrect formula. 7. Brett likes to keep track of the total number of current invoices he has sent to clients. In cell B17, enter a formula using the COUNT function that counts the invoice numbers (the range A6:415). 10/10 10/10 10/10 0/10 Create a formula using a function. 8. Brett also likes to keep track of the approximate amount he has billed clients. In cell B18, enter a formula using the ROUND and SUM functions that totals the invoice amounts (the range D6:D15) and rounds the result to 0 decimal places. Create a formula using a function. 9. Go to the Quarter 3 Sales worksheet. Apply the Accounting number format to the sales amounts (range B6:B11) to indicate they are dollar amounts. Change the number format. 10. Brett wants to calculate the percentage of each category of insurance contributed to his total sales. Because he also wants to avoid a divide by zero error in the calculation, he has already entered the IFERROR function. Complete the formula as follows: a. In cell C6, before the comma in the FERROR function, create a formula without using a function that divides the amount of automobile insurance sales (cellB6) by the total sales (cell B11). b. Use an absolute reference to cell B11 in the formula. c. Use the Fill Handle to fill the range C7.C10 with the formula in cell C6. X Create a formula using a function. In the Quarter 3 Sales worksheet, the formula in cell C6 should contain an absolute reference to cell B11. X Copy a formula into a range. In the Quarter 3 Sales worksheet, cell C6 contains an incorrect formula. 10/10 1. Brett Thao is an insurance agent for the Great Midwestern Insurance in Milwaukee, Wisconsin. He is analyzing the invoices he has sent clients and the sales he generated in the third quarter of the year. He asks you to help him complete the analysis. Go to the Client Invoices worksheet. In cell B3, insert a formula using the DATE function to display the current date as 6/1/2021 (m/d/yyyy) so that Brett can use the date in calculations. [Mac Hint: The date will display using the format m/d/yy.] Create a formula using a function. 2. In column F, Brett wants to display the age of the invoice, which is the number of days between the current date and the invoice date. Provide this information as follows: a. In cell F6, insert a formula without using a function that subtracts the invoice date (cellB6) from the current date (cell B3). b. Use an absolute reference to cell B3 in the formula. c. Use the Fill Handle to fill the range F7:F15 with the formula in cell F6, filling the range without formatting. 0/10 X Create a formula without using a function. In the Client Invoices worksheet, the formula in cell F6 should subtract the value in cell B6 from the value in cell B3. X Copy a formula into a range. In the Client Invoices worksheet, cell F6 contains an incorrect formula. 3. In column G, Brett wants to calculate the number of days the invoice is overdue. If the age of the invoice is greater than 30 days, it is overdue. Calculate the days overdue as follows: a. In cell G6, insert a formula using the IF function that tests whether the age of the invoice (cell F6) is greater than 30. b. If the age of the invoice is greater than 30, subtract the due date (cell E6) from the current date (cell B3). c. If the age of the invoice is less than or equal to 30, display 0 to show that the invoice is not overdue. d. Use an absolute reference to cell B3 in the formula. e. Use the Fill Handle to fill the range G7: 615 with the formula in cell G6, filling the range without formatting. 10/10 10/10 Create a formula using a function. Copy a formula into a range. 4. Brett sends an email reminder to clients with overdue invoices for amounts more than $1,000. Provide a quick way to identify those clients as follows: a. In cell H6, insert a formula using the AND function that returns TRUE if the number of days overdue (cell G6) is greater than 0 and if the invoice amount (cell D6) is greater than 1000. b. Use the Fill Handle to fill the range H7:H15 with the formula in cell H6, filling the range without formatting. AutoSave OFF A @@ 9 Huc IL_EX19_3a_MeghanCorrigan_2 Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Calibri (Body) 11 Insert v V 20 ab Wrap Text General 28-O Delete Paste B I U QvA V E == 333 Merge & Center v $ v % V , Co-29 Conditional Format Cell Formatting as Table Styles E Sort & Filter Format v Find & Select Sensitivity Analyze Data MAX x fx =DAYS(B3$B$3,B6) X $) DAYS(end_date, start date) A B D E F G H I 1 1 Great Midwestern Insurance Client Accounts 2 6/1/21 Ratin Days Overdue 48 48 30 30 Invoice Date Account Name 3/15/21 Miguel Grazia 3/15/21 Melissa Sullivan 4/2/21 Ruth Hahn 4/2/21 Troy Danz 5/1/21 Jeong Pen 4/15/21 Tom Marlowe 5/1/21 Brent Pederson 4/15/21 Charles Korato 5/15/21 Alex Munoz 5/15/21 Anna Napier Amount 1,425.15 907.88 915.65 1,023.33 824.80 1,095.67 1,045.50 1,235.33 1,127.75 804.67 $ $ $ $ $ $ $ $ $ $ 3 Current date: 3 4 5 Invoice Number 6 1894 7 1907 8 1988 9 1997 10 2003 11 2004 12 2014 13 2021 14 2045 15 2053 16 17 Total invoices: 18 Total amount: 19 20 21 1 Client Invoices Due Date Age of Invoice 4/14/21 =DAYS(B3$B$3,B6) 4/14/21 78 5/2/21 60 5/2/21 60 5/31/21 31 5/15/21 47 5/31/21 31 5/15/21 47 6/14/21 17 6/14/21 17 Email TRUE FALSE FALSE TRUE FALSE TRUE TRUE TRUE FALSE FALSE > 00 00 00 00 noon 17 B 1 17 0 A 0 A 10 $ 10,406.00 Documentation Client Invoices Quarter 3 Sales + Point 191% AutoSave OFF A @@ 9 Huc IL_EX19_3a_MeghanCorrigan_2 Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Calibri (Body) 11 20 ab Wrap Text General Insert v QvA ( 28-Or Delete Paste BIU E V Merge & Center v $ v % , Sort & O O V Conditional Format Cell Formatting as Table Styles Sensitivity Format Find & Select Filter Analyze Data MAX x =( x fx =DAYS(B3$B$3,B6) B D E F G H T J 2 Client Accounts 3: 6/1/21 uw N 4 5 ber Age of Invoice Days Overdue 48 Email TRUE FALSE Rating 64 no 48 C 7 7 8 8 78 60 30 DAYS(end_date, start date) TRUE 60 30 C Invoice Date Account Name 3/15/21 Miguel Grazia 3/15/21 Melissa Sullivan 4/2/21 Ruth Hahn 4/2/21 Troy Danz 5/1/21 Jeong Pen 4/15/21 Tom Marlowe 5/1/21 Brent Pederson 4/15/21 Charles Korato 5/15/21 Alex Munoz 5/15/21 Anna Napier Amount 1,425.15 907.88 915.65 1,023.33 824.80 1,095.67 1,045.50 1,235.33 1,127.75 804.67 1 Client Invoices Due Date 4/14/21 4/14/21 5/2/21 5/2/21 5/31/21 5/15/21 5/31/21 5/15/21 6/14/21 6/14/21 $ $ $ $ $ $ $ $ $ $ B 31 47 17 Discour FALSE TRUE TRUE FALSE TRUE FALSE FALSE FALSE TRUE TRUE B 31 1 B FALSE TRUE TRUE TRUE FALSE FALSE 97 10 3 11 4 12 4 13 1 1 14 5 15 3 16 17 s: 18 t: 19 20 47 17 B 17 0 A 17 0 A 10 $ 10,406.00 21 22 Documentation Client Invoices Quarter 3 Sales + Point 191% C6 fx =IFERROR(B6/B$11, "ERROR DIVIDE BY 0") B C D E F G 1 Great Midwestern Insurance Sales Summary % of Total 2 3 4 5 Category 6 Automobile 7 Casualty 8 Homeowners 9 Personal property 10 Renters 11 12 13 Quarter 3 Amount $ 10,453.25 $ 8,755.67 $ 9,877.35 $ 8,034.80 $ 7,523.50 Total $ 44,644.57 23% 20% 22% 18% 17% 23%