Thread: Formula
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
PJFry PJFry is offline
external usenet poster
 
Posts: 143
Default Formula

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