How to round values to the nearest 1000?
Like: 12,549,235 > 12,549,000
Like: 12,549,735 > 12,550,000
According to Help I should use =ROUND(P9,3-LEN(INT(P9))) but the result
is not what I want.
Bart
Excell 2003
How to round values to the nearest 1000?
Like: 12,549,235 > 12,549,000
Like: 12,549,735 > 12,550,000
According to Help I should use =ROUND(P9,3-LEN(INT(P9))) but the result
is not what I want.
Bart
Excell 2003
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks