## Excel formulas on each row

Asked By 0 points N/A Posted on -

I need to increase the price of commodities that are entered into an Excel worksheet by 5%. Please detail me the procedure of calculating and entering the new price into each row. Also, I would like to know about the function that will help you in returning the name of the worksheet in Excel.

SHARE
Answered By 0 points N/A #93877

## Excel formulas on each row

There are lots of ways to solve your problem in increasing prices of commodities in your Excel Worksheet by 5%. First of all, you must enter it manually to increase it to 5%.

For example you entered a date in a cell 500. You may write in a its column as "Previous Price" then the right side column you will add "Increased by 5%.

 Previous Price Increased by (%) Present Price 500 5 525 300 5 315 200 5 210

The formula you will use in getting the accurate result is type this in the cell in your present prices =SUM (Previous Price/100*5+Previous Price), then you'll get your result.