"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.
Divide by 1000, round, then multiply by 1000.
--
Peter Aitken
Remove the crap from my email address before using.
|