heater wrote:
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.

You got your answer, and there is nothing wrong with
it. But I'm curious .... Why not simply round the IF()
result? That is:

= ROUND(IF(..., ..., ...), -3)

Probably easier for someone else to read. It does not
matter that 500000 is already rounded to the desired
degree.

The only time that would not work for you is if you
do not want the result of one of the clauses to be
rounded. I think that would be unusual. For example:

=IF(..., 543210, ROUND(..., -3))

PS: Are you sure you wrote the nested IF() functions
as you intended for your purposes? They result in the
word "FALSE" when $C$19 is 500000, but it results in
500000 when $C$19 is less than 500000. Seems a bit odd.