sum less than then... sum more than then...

Hi there,

I am trying to produce a sheet calculating income from film distribution. But I am stuck. The good thing is that I think you guys can help me very easily.

What I need is a formula to do this:

Take a number from a field (let's say C5), subtract 2 500 000, divide the outcome by 2. Then (the tricky part...) If the outcome is less than zero then it should show 0, if the outcome is more than 9 000 000 then it should show 9 000 000. (The minimum is 0 and the max is 9000 000.)

Any suggestions?

All the best, thanks in advance,

Patrik