• 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

xlstime

Active Member
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
 

David Evans

Active Member
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

Top