How to subtract formula in excel

broken image
broken image

In this example, columns C through H show the sales for each month.

broken image

Unfortunately, Excel doesn’t have a SUBTRACT formula. You need to subtract the prior month’s sales from the current month’s sales. Your boss asks you to add a row that shows the change from the prior month. You have created a report that shows your company’s sales by month.

broken image