Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
How do I calculate an answer with different % intervals from one amount:
Example : the amount = 70 000 The intervals 0 - 39999 = 30% then from 40000 - 59999 = 40% then from 60000 - 70000 = 50% the answer will then be 24998.8 |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
How did you arrive at the 24998.8? The example you gave doesn't give enough
information to solve the problem. -- Regards, PJ Please rate this post using the vote buttons if it was helpful. "Cobus" wrote: How do I calculate an answer with different % intervals from one amount: Example : the amount = 70 000 The intervals 0 - 39999 = 30% then from 40000 - 59999 = 40% then from 60000 - 70000 = 50% the answer will then be 24998.8 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|