Cost vs retail
Will this work:
=ROUNDUP((A1*1.5),0)-0.01
Change A1 to match your cell reference.
HTH,
Elkar
"cochum" wrote:
I am creating a spread sheet to make marking up cost easier and standard.
The only thing is that I want to always have a .99 cent ending ont he retail.
So I want everthing to have a 50% mark up, but to always end the retail in a
.99 ending. How do I do that?
|