Excel formulas on each row

Asked By marlin zee 0 points N/A Posted on - 01/13/2012

 

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.

• Status: Open
• Question Views: 1030
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: MS Excel

Best Answer by Pallasigue Stabins

Go To Solution

Answered By JoyCaliso 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.

About JoyCaliso

Questions
0

Answers
8

Best Answers
3

• Vote Up 0 Vote Down

• Posted on - 01/20/2012
• Question Category: MS Excel

Best Answer

Best Answer

Answered By Pallasigue Stabins 0 points N/A #93878

Excel formulas on each row

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.

 

About Pallasigue Stabins

Questions
1

Answers
63

Best Answers
26

• Vote Up 0 Vote Down

• Posted on - 03/23/2012
• Question Category: MS Excel