Excel formulas on each row

Asked By 0 points N/A Posted on -
qa-featured

 

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
Best Answer by Pallasigue Stabins
Answered By 0 points N/A #93877

Excel formulas on each row

qa-featured

 

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.

Best Answer
Best Answer
Answered By 0 points N/A #93878

Excel formulas on each row

qa-featured

Here I have shown the whole document to make it clear for you. Suppose, you have 6 types of products X, Y, Z, XY, YZ, ZX. I have put those products names in the cell range A2:A7. In the range of B2:B7, the previous price is written down. In the C column I have put the rate of percentage. In the column D, the value of that percentage is shown. If you multiply B column with C column, then you will get the D column which is the additional price of those products. In column E, if you put this formula =B2* (1+C2), then you will get the current price. You can also use =B2+D2 instead of =B2* (1+C2).

 

Hope this helps.

 

Login/Register to Answer

Related Questions