LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how do i do profit formulas wendy Excel Worksheet Functions 1 September 19th 08 04:02 PM
Net profit mASSIVEMIKE Excel Discussion (Misc queries) 8 December 10th 07 03:06 PM
gross profit econacumen Excel Worksheet Functions 2 November 27th 06 11:15 PM
Profit only if B2=33 and C2=18, please help Jspearm Excel Discussion (Misc queries) 1 February 22nd 06 07:15 PM
Non-profit database? wirthless Excel Discussion (Misc queries) 3 October 30th 05 10:12 PM


All times are GMT +1. The time now is 07:23 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"