Profit calculation

[Rob]

Hello All,

I am looking for some help in putting in an excel calculation. I am trying
to automate the calculations but dont quite understand how to achieve this.

What I need to be able to do is in enter a figure in row D minus row E then
= row G. In row F I need the percentage difference. Then I need all the
entries in row D added together to give me a total charge. Row E the same for
the Pay. And then the total of both in another column to give a total profit
made. And the percentages all added and then averaged out as a total too.

Sounds complicated I know, but I am sure there is a wiz out there they
probably has already done it, or something similar and can do this easy peasy.

Any help would be wonderful.

Thanks

Rob

 

[Fred Smith]

Let's take it one step at a time.

1. Assuming you're starting on row 2, in G2 enter =d2-e2. Fill down.
2. In F2, enter =g2/d2 or =g2/e2 depending on what your want to calculate
the percentage of. Format as percent. Fill down.
3. At the bottom on columns D, E and G, sum the totals, as in =Sum(d2:d100)
4. The percentage calculation for this total row would stay the same.

Regards,
Fred

 

[Bernard Liengme]

Try this on a new worksheet and see if we are getting anywhere near what you
need
In D2 enter 90
In D3 enter 100
On E2 enter 10
In E3 enter 15
In G2 type: =D2-E2 and press Enter key (you should see value 80 displayed)
Click on G2 and note the small solid square in lower right corner - the fill
handle
Move mouse over the fill handle - see how the mouse point changes from a
black + to an open +
With this open = visible drag the mouse point down to the next cell G3
Note how the formula gets copied
QUOTE In row F I need the percentage difference END QUOTE
For the difference between D and E as a percentage of D use formula
=(D2-E2)/D2
Copy this formula done to the next row as before
But you may need to come back with clarification if you get the wrong answer

In D20 (let's say you are not entering too many items in the columns) type
=SUM(D219)
You should see 190. Now type 110 in D4 and you should see 300
Drag the fill handle of D20 across to E20, F20 and G20: see that you now
have the sums of these columns

If all this seem like fun, then it is time to buy Excel for Dummies and get
more familiar with the basics
best wishes
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email