LisaVelthuizen
New Member
- Joined
- Nov 14, 2017
- Messages
- 4
I am making a calculator for my website (i make the calculator in the program excel), but i don't know which formula i must take and how to fill it in.
It is a formula where the answer depends on the input and bandwidth of the input.
Below the input en output:
Input: ≤30.000 --> the answer must be 800.
between 30.000 and 60.000 -> every 1.000 upon the 30.000, but till an input of 60.000 --> the answer increases with 19,5 upon the first 800. So 60.000 must have the answer 800+ (30*19.5) = 1.385
Between 60.001 and 100.000 -> every 1.000 upon the 60.000, but till an input of 100.000 --> the answer increases with 15,60 upon the 1.385. So 100.000 must have the answer 800+ (40*15.60) = 2.009.
This principle continues. In numbers:
Input: Output:
≤30.000 -> answer = 800
30.001 - 60.000-> per 1.000 upon the input, the answer increases with 19.50 above the first 800.
60.001 - 100.000 > per 1.000 upon the input, the answer increases with 15.60 above the first 800+19.50 per 1.000(see line before).
100.001 - 200.000 -> per 1.000 upon the input, the answer increases with 7.80 above the first 800+19.50 per 1.000+ 15.6 per 1.000(see line before).
200.001 - 500.000 -> +5.85 per 1.000 ( but again above the first answers)
500.001 - 1.000.000 -> + 4.875 per 1.000 (but again above the first answers)
1.000.001 and higher -> +2.925 per 1.000 (but again above the first answers)
These numbers has to fill in one formula. Does anybody know which formula i can use and how i use it?
It is a formula where the answer depends on the input and bandwidth of the input.
Below the input en output:
Input: ≤30.000 --> the answer must be 800.
between 30.000 and 60.000 -> every 1.000 upon the 30.000, but till an input of 60.000 --> the answer increases with 19,5 upon the first 800. So 60.000 must have the answer 800+ (30*19.5) = 1.385
Between 60.001 and 100.000 -> every 1.000 upon the 60.000, but till an input of 100.000 --> the answer increases with 15,60 upon the 1.385. So 100.000 must have the answer 800+ (40*15.60) = 2.009.
This principle continues. In numbers:
Input: Output:
≤30.000 -> answer = 800
30.001 - 60.000-> per 1.000 upon the input, the answer increases with 19.50 above the first 800.
60.001 - 100.000 > per 1.000 upon the input, the answer increases with 15.60 above the first 800+19.50 per 1.000(see line before).
100.001 - 200.000 -> per 1.000 upon the input, the answer increases with 7.80 above the first 800+19.50 per 1.000+ 15.6 per 1.000(see line before).
200.001 - 500.000 -> +5.85 per 1.000 ( but again above the first answers)
500.001 - 1.000.000 -> + 4.875 per 1.000 (but again above the first answers)
1.000.001 and higher -> +2.925 per 1.000 (but again above the first answers)
These numbers has to fill in one formula. Does anybody know which formula i can use and how i use it?