Thread: Rounding up to nearest 500
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Teethless mama Teethless mama is offline
external usenet poster
  
Posts: 3,718
Default Rounding up to nearest 500
=ROUNDUP(A1,-2)

"Heather" wrote:

Call me crazy, but I have read every rounding question and answer and I
cannot get Excel to round up to the nearest 500.

IE: 525446 needs to be 525500

Can anyone help! Heather
Reply With QuoteReply With Quote