Formula

  • Thread starter Thread starter Cobus
  • Start date Start date
C

Cobus

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
 
How did you arrive at the 24998.8? The example you gave doesn't give enough
information to solve the problem.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Lookup ? 4
EXTREMELY URGENT REQUEST... Re: Grouping 7
excel formula 3
Help with nested formula 7
Calc Speed & Formula simplification 2
Spreading Formulas across the whole document 6
Formula 2
help with error 1

Back
Top