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

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