just literally maybe
=MAX((A1<600)*600,ROUND(A1/600,0)*600)
for +/- numbers only
--
*****
birds of the same feather flock together..
"Barcelona" wrote:
I need to round numbers to the nearest multiple of 600. For example if the
number is 15,443, I am looking for a formula that would round the number to
15,600. Is there one?
Judy Sanchez