You are creating a formula in Excel that uses the following information Monthly Expenses are in cells A2 A6 Yearly Expenses are

Question

You are creating a formula in Excel that uses the following information Monthly Expenses are in cells A2 A6 Yearly Expenses are in cells B2 B4 To create your formula you need to add all the yearly expenses then divide by 12 Then add the sum of the monthly expenses to find the adjusted monthly amount What would this formula look like A 1 2 3 4 5 6 Monthly Expenses Yearly Expenses 1 000 00 279 00 197 82 50 00 100 00 75 00 32 75 47 85 A SUM B2 B4 12 SUM A2 A6 B B SUM A2 A6 12 SUM B2 B4

Kunduz · Accepted Answer

Click to see the answer