Rounding a result in the same cell

I want to round a cell with an existing formula in it.

this is the formula: =+'Revenue Projection'!M1 and it shows as $8,541,403 (it is a result from another sheet)

I want to round that number in the same cell to the nearest $1000 ($8,541,000)

Anybody know how to get this done?

Try

=ROUND('Revenue Projection'!M1,-3)

Originally Posted by daddylonglegs

Try

=ROUND('Revenue Projection'!M1,-3)

OUTSTANDING! That worked! Thank you very much!