Thread: rounding up for number not for decimal
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming,microsoft.public.excel
Frank Kabel Frank Kabel is offline
external usenet poster
  
Posts: 3,885
Default rounding up for number not for decimal
Hi
=ROUNDUP(A1,-3)
or
=CEILING(A1,1000)

"Admin" wrote:

I have excel 2003 installed on my machine all what I am looking for to round
up the number
not the decimal
example roundup 15600.00 to 16000.00
example roundup 14780.00 to 15000.00

any one know



Reply With QuoteReply With Quote