Percentage decrease in Microsoft Excel 2019

We are working in cell J10 of the first worksheet of theConvertingValues.xlsx workbook to calculate the product pricedecrease as we are having a store sale. This calculation is the same asthe preceding percentage increase formula, except we will use a minussign instead of an addition sign in the last part of the formula, as weare wanting a decrease in ProductPrice. Type =H10*(1-I10) into cell J10 of Sheet1, as illustrated in the followingscreenshot:

ms office 405

Now, we will learn how to customize the status bar in the next topicto obtain a quick peek at various calculations on the worksheet.

Leave a Comment