Thread: rounding currency amounts
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
מיכאל (מיקי) אבידן מיכאל (מיקי) אבידן is offline
external usenet poster
  
Posts: 561
Default rounding currency amounts
Try using the CEILING Function.
Micky


"sruarg" wrote:

i would like to round a currency amount to the next $ 0.05 (five cents)

eg 30.63 to be 30.65 or 40.48 to be 40.50
Reply With QuoteReply With Quote