Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Profit calculation
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 -- Newbie |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Profit calculation
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 "Rob" wrote in message ... 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 -- Newbie |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Profit calculation
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(D2:D19) 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 "Rob" wrote in message ... 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 -- Newbie |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i do profit formulas | Excel Worksheet Functions | |||
Net profit | Excel Discussion (Misc queries) | |||
gross profit | Excel Worksheet Functions | |||
Profit only if B2=33 and C2=18, please help | Excel Discussion (Misc queries) | |||
Non-profit database? | Excel Discussion (Misc queries) |