LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 54
Default Calculate X1-5 and Y? If total cost is given.

Hi,

I was wondering if someone could help me.

I have 5 projects with different set of revenues.

Project Rev Cost Profit margin
P1 50000 X1 Y
P2 10000 X2 Y
P3 100000 X3 Y
P4 20000 X4 Y
P5 50000 X5 Y

I have total cost of X1-5 = 270000,-

And now I want the 270 000 to be distributed on my 5 project so that they
all have the same profit margin Y.

--
Regards Anders
 
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
Total Cost Curve Graph sross002 Excel Discussion (Misc queries) 0 April 27th 07 01:54 PM
How do I generate a total cost for user selected rows? DLund Excel Discussion (Misc queries) 2 April 2nd 07 10:40 PM
How to calculate total cost using fixed hourly rate from [h:mm:ss:]? Pheasant Plucker® Excel Discussion (Misc queries) 4 November 2nd 06 06:14 PM
Sub Total Cost by MFG lax58 Excel Discussion (Misc queries) 2 June 27th 05 08:36 PM


All times are GMT +1. The time now is 10:43 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"