View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Rob Rob is offline
external usenet poster
 
Posts: 718
Default 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