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
|