• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

formula to calculate value based on threshold

Friends,

Please see attached file and if you could please suggest a single formula that will provide the value and

two separate formula that will shows the thresholds separately

thank you
 

Attachments

  • Formula.xlsx
    11.7 KB · Views: 8
Hey Ecel Dumbo,

There are many ways to do this but first you need to create a table for tax-logic as excel can not read from string like "$39,540 for the first $2,947,000, then 2% over that "

thn you can apply either IF condition or lookup.

table should be look like -
col1 col2
0 0
1000 2%
3000 3%

like that.




Friends,

Please see attached file and if you could please suggest a single formula that will provide the value and

two separate formula that will shows the thresholds separately

thank you
 
I've uploaded a file with a similar calculation for you Ecel Dumbo - indeed it has several ways of doing it including a UDF.

The most interesting thing about this file was that I realized you must have asked a similar question earlier, as I've provided a sheet with a solution for you in it ...

xlstime's solution is in there, together with some other techniques - there are many ways to solve this problem - choose whatever one works for you.
 

Attachments

  • Tiered Schedule examples.xlsm
    26.1 KB · Views: 11
Back
Top