Name the cell where the total is calculated Total and put your 16 824 in some cell and name it 'bval' (which appears to be your base value, whence bval), then use the formula:

=IF(Total<bval,0,IF(Total<2*bval,Total-bval,IF(AND(Total>2*bval,Total<10*bval),Total/2,IF(Total>10*bval,Total-5*bval,""))))

Aladin

In my previous post, the formula was crippled during paste. Here is the correct one:

=IF(Total<bval,0,IF(Total<2*bval,Total-bval,IF(AND(Total>2*bval,Total<10*bval),Total/2,IF(Total>10*bval,Total-5*bval,""))))

See for "Total" and "bval" the previous post.

Aladin

Things are messed up in my earlier attempts to post. It seems Copy and Paste doesn't work!

What I wanted to say is:

Name the cell you calculate the total "Total", put the number 16824 in a cell and name "Bval" (which appears to be your base value).

Then use the formula:

=IF(Total<Bval,0,IF(Total<2*Bval,Total-Bval,IF(AND(Total>2*Bval,Total<10*Bval),Total/2,IF(Total>10*Bval,Total-5*Bval,""))))

Cheers.

Aladin

I give it up. It seems impossible to type the formula!

Here another alternative:

=+IF(Total>168240,Total-84120,IF(Total>33648,Total/2,IF(Total>16824,Total-16824,0)))

good luck