How to return data if a value falls between a range
I am trying to make a formula to calculate certain costs associated with a property value, based on its value.
See below:
Value of Property Rate to apply Deduction Up to €92,407 0% Nil €92,407 – €126,403 2% €1,848.14 €126,403 – €172,348 5% €5,640.23 €172,348 – €287,213 7% €9,087.19 €287,213 – €574,323 8% € 11,959.32 over €574,323 6% Nil
So when I enter the actual value of a property, say €275,000 somewhere in it my spreadsheet should look up in which range it falls, pick up the correct % and make the calculation.
Can you please advise the best way for this?
Kind regards,
Martin
I am trying to make a formula to calculate certain costs associated with a property value, based on its value.
See below:
Value of Property Rate to apply Deduction Up to €92,407 0% Nil €92,407 – €126,403 2% €1,848.14 €126,403 – €172,348 5% €5,640.23 €172,348 – €287,213 7% €9,087.19 €287,213 – €574,323 8% € 11,959.32 over €574,323 6% Nil
So when I enter the actual value of a property, say €275,000 somewhere in it my spreadsheet should look up in which range it falls, pick up the correct % and make the calculation.
Can you please advise the best way for this?
Kind regards,
Martin
No comments:
Post a Comment