Hi All,

It's me again.
I wonder if EXCEL able to round off some numbers on the cell (sorry my english so bad).
Say:
A1 5000
B1 5750
C1 5678
D1 16428 (summarize)
Is it possible to make D1 automatically change its value into 16000 or if the result 16750 then it will change to 17000?

Thanks, all master here able to provide me some solutions.

TY&Rgds,
faried