Assuming Project Cost is in cell A1, try this:

=(MIN(A1,100)*0.1)+IF(A1100,(A1-100)*0.08,0)+IF(A1500,(A1-500)*0.05,0)

HTH,
Elkar

"Captain Steve" wrote:

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!!