Rounding a formula amount down

[nickpavlov]

A simple formula: =C21-C11

How can this result be rounded down to the nearest 100,000.

Say the result is 864,900 I would want 800,000 to be shown.

Is this possible?

Thanks for any help,
Nick

[Phuocam]

Try:

=ROUNDDOWN(C21-C11,-5)

[nickpavlov]

That worked perfect! Tahnks Phuocam!