Thread: Is there a way to round currency?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Ron Coderre
 
Posts: n/a
Default Is there a way to round currency?
Try this:

For a value in A1
B1: =FLOOR(A1,0.5)+0.49

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"jpowers" wrote:

Is there a way to round currency with cents=.50 to .99 and cents <=.49 to .49?
Reply With QuoteReply With Quote