Excel problem Closed

Question

Hello,
        dear sir,i have a excel problem.I have four coloums like:
"month"  "1st value" "2nd value" "total value"

now some value like this put on


"jan"    100      100        200

now i want like this 

"feb"  "any value + 3% of total value of jan"   100     total value

"march" "any value + 3% of total value of feb"   100     total value

i wants if  i puts any value in "1st value" colum's cell.In this value,the 3% share of upper month's"total value" must 
be added automatically.  
plz tell me it is possible or not.
if it is possible tell me its solution.

Aadhi · Answer

Hi,
Am not going for Macros here. In normal way to achieve this. just follow this:

you have:

     A    B     C    D
1  Jan 100 100 100 
2  Feb 200 100 300
3  Mar 100 400 500
 
(Note: Here A B C D denotes rows and 1 2 3 4 denotes columns. So, A1 cell refers to "Jan")



Step 1: 
In the B2 cell (which has 200), in the formula bar (In between end of toolbars and the "A B C D..." row heading, which shows the actual value or the formula of the cell). There type =200 + (3*D1)/100. Which now shows the 3% summed up with the 200.

Step 2:
Click the B2 cell, in that highlighted cell, you could find a small square at the right bottom verge. Drag that downwards (assuming the "Mar" values you enter below "Feb").

Step 3:
Click the B3 cell and in the formula bar give your original value instead "200" ("200" will be present there automatically). 

You shall drag and change it, else you shall do the step 1 alone for all the individual cells, where you want that 3% summed.


Regards!
Aadhi

Excel problem

1 response

Similar discussions

Subscribe To Our Newsletter!