Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default rate of decrease with fixed ratio method

Hello everyone!
I'm trying to make this, but don't know:

We have:
Amount of money: 1000 (changeable)
Beginning # of units: 0,1 (changeable)
Delta: 200 (changeable)
Rate of decrease: 50% (changeable)

0,1 unit should be added for every 200$ increase of the sum
(1000+200=1200; 1200+200=1400; 1400+500=1900; 1900+256=2156 etc)
0,1 unit should be taken away after decreasing by100$ (because the rate
of decrease = 50% (changeable))

After increasing of 1000 + 200, quantity of units should also increase
for 0,1, so it should be 0,2 (1200), 0,3(1400), 0,4(1600)..... Amount
of money can increase not only by 200, but for any sum. If that sum is
(for example) 500, we should increase by 0,2 etc.

But when this some decreasing we are using rate of decrease (for
example 50%, (changeable):
0,4 units - 1600
0,3 units - 1500
0,2 units - 1400
0,1 unit - 1300

I'll be appreciate for any help!
Alex Vasyuta

Reply
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
financial function ..please [email protected] Excel Worksheet Functions 4 July 29th 06 09:30 PM
bank cal for interest on cd Frank Malone Excel Worksheet Functions 12 June 11th 06 10:27 PM
XNPV vs. NPV(quarterly) different results magis Excel Worksheet Functions 3 January 6th 06 05:21 PM
loan calculator, int rate changes and fixed prin payment skip770 Excel Discussion (Misc queries) 0 December 15th 05 02:41 PM
drawdown at fixed rate over set period from investment at fixed % jamook New Users to Excel 1 November 28th 05 10:53 PM


All times are GMT +1. The time now is 09:12 AM.

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

About Us

"It's about Microsoft Excel"