Hi All-

I want to write a formula that will look at project value and assign a % fee
charge as follows: Project 0 - $ 100, Fee 10%; Project $101 -$500, Fee 8%,
Project above $501, Fee 5%.

I can write the formula that looks at project cost and finds fee,

BUT I want to set it so that a $600 project will generate a 10% charge for
first $100, 8% charge for next $399 and a 5% charge for the remaining $99.

How do I do it?

Many Thanks!!