Hello,
I'm still learning Excel and I'm either not calling it the right thing or it's just so easy i'm over thinking it.
I want to create a calculator for building permit fees.
A lot of permits are based on the project valuation.
Example:
Charge for first $1,000 of valuation.......$40.00
$1,001 to $50,000..............................$9.00 per thousand
$50,001 and above.............................$8.00 per thousand
If the valuation of a project is $100,000 dollars then i have to do this
100,000- 1,000 for the first valuation will charge me $40.00. I then have to take the remaining cost and go to the next tier ($9.00). So 99,000-50,000 will make me take the 50*$9.00 = $450.00 . I then have 49,000 left of the value so it will be 49*$8.00 = 392.00.
I want to make a formula that i can just type the valuation in and it will calculate it for me.
PLEASE HELP ME!
Bookmarks