Excel problem

Closed
sandhu - Jan 7, 2009 at 05:24 AM
ogonda - Jan 7, 2009 at 07:48 AM
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
plz tell me it is possible or not.
if it is possible tell me its solution.
Related:

1 response

Aadhi Posts 17 Registration date Tuesday December 9, 2008 Status Member Last seen January 7, 2009 3
Jan 7, 2009 at 06:12 AM
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!