#1   Report Post  
Posted to microsoft.public.excel.misc
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



  #2   Report Post  
Posted to microsoft.public.excel.misc
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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 02:45 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"