It actually is

=IF($C$19<5000000,500000,IF($C$195000000,ROUND((D 52/$D$95)*$C$19,-3)))

Thanks for the direction.

"Anne Troy" wrote:

Ooops!!
=IF($C$19<5000000,500000,IF($C$195000000,round((D 52/$D$95)*$C$19),-3)))
*******************
~Anne Troy

www.OfficeArticles.com


"heater" wrote in message
...
Where does the Round go in the following formula:

=IF($C$19<5000000,500000,IF($C$195000000,(D52/$D$95)*$C$19))

I want it to round to the nearest 1,000.