Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
mathematician dummy needing assistance
Do someone could help me solving the following problem
U E C 2'000'000.- 1'000'000.- 5'00'000.- Initial amounts -20'000 -12'000.- -53'000.- Amounts variation -1.00% -1.20% -1.06% % in pourcentage 100.00% 120.00% 106.00% poucentage ratio beween themselves 100.00% 96.00% 98.00% pourcentage ratio wished -1641.5 (0) (a)1621.5 (b)20 amounts add or soustracte in order to .................................................. ........................reach the wishes ratio -21641.5 -10378.5 -52980 modified amounts by line above -1.08% -1.04% -1.06% % gain/loss with modified variations 100.00% 95.91% 97.92% ratio with the modified amounts between % How can I reach the % ratio wished , with changing only the (a) and (b) amounts which influence the (0) amount with this formula =-(a+b) My aim is to find a way to automatically calculate (a) and (b) knowing only the wished ratio and the real ratio betwen % gain / loss Thanks for your help |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
mathematician dummy needing assistance
I'm not clear on what you want to do. Can you show an equation to get what
you want and we can help convert it to an EXCEL formula? wrote in message oups.com... Do someone could help me solving the following problem U E C 2'000'000.- 1'000'000.- 5'00'000.- Initial amounts -20'000 -12'000.- -53'000.- Amounts variation -1.00% -1.20% -1.06% % in pourcentage 100.00% 120.00% 106.00% poucentage ratio beween themselves 100.00% 96.00% 98.00% pourcentage ratio wished -1641.5 (0) (a)1621.5 (b)20 amounts add or soustracte in order to .................................................. .......................reach the wishes ratio -21641.5 -10378.5 -52980 modified amounts by line above -1.08% -1.04% -1.06% % gain/loss with modified variations 100.00% 95.91% 97.92% ratio with the modified amounts between % How can I reach the % ratio wished , with changing only the (a) and (b) amounts which influence the (0) amount with this formula =-(a+b) My aim is to find a way to automatically calculate (a) and (b) knowing only the wished ratio and the real ratio betwen % gain / loss Thanks for your help |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
mathematician dummy needing assistance
In fact I m unable to put that in equation I m affraid,
the aim of this calucation is to smooth a result by a given ratio. To find the good amounts I have to try hundreds of combinations. to resume what i m looking for I can only put it like this. IF 0 = 1% B= 1.20% C=1.06% how much should I take from 0 and give to B and C in order that B= 96% of 0 and C = 98% of 0 . Of course 0 won't 'stay at 1% . Hope it's a litte bit clearer . Otherwise I have an excel spreadsheet I can forward to you if you wishe. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to hide a dummy series in a chart legend? | New Users to Excel |