View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Ron Coderre Ron Coderre is offline
external usenet poster
 
Posts: 2,118
Default Rounding off to .48 or .98

Maybe something like this?:

With
A1: (original price)

This formula rounds up to the nearest $0.48 or $0.98
B1: =CEILING(A1*1.03,0.5)-0.02

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"Mark4253" wrote:

Hi!
My company is increasing prices 3%. My boss likes everything rounded off to
the nearest 48 cents or 98 cents. Is there a formula for increasing our
prices 3% then rounding it off to the nearest 48 cents or 98 cents, whichever
is closer after being increased 3%. Thanks,
--
Mark