Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
incremental charges
how do I get the right amount to populate in the monthly total when the amounts change? if total is 20k then range 1 would be 10,000 and range 2 would 9,999 and range 3 would be 1- jp17
- Post #9
- Forum: Microsoft: Office
-
incremental charges
it's based on volume, so in this scenario this month the volume is 65k and for the 1st 10k I need to calculate the right amount within the ranges @ .05 and the next range to calaculate @ .06 but I can't get the formula to work.- jp17
- Post #7
- Forum: Microsoft: Office
-
incremental charges
Sorry, let me try again Volume 65,000.00 .....Range........................Monthly Totals..... ...........Rate...............Billable ........0 ………….. 10,000 ………….. 10,000 …………. 0.05 ………….. $500.00 ………….. 10,001 ………….. 20,000 ………….. 9,999 ………….. 0.06 …………...- jp17
- Post #4
- Forum: Microsoft: Office
-
incremental charges
would like to calculate charges @ stages. I can't the formulas to work Range Rate Billable 65000 0 10,000 10,000 0.05 $500.00 10,001 20,000 9,999 0.06 $599.94 20,001 30,000 9,999 0.07 $699.93 30,001 40,000 9,999 0.08 $799.92 40,001 50,000 9,999...- jp17
- Thread
- Replies: 14
- Forum: Microsoft: Office
