Thread: Cost vs retail
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
cochum
 
Posts: n/a
Default Cost vs retail

Thanks this one worked perfect!

"Dave Peterson" wrote:

Maybe...

=ROUNDUP(A1*1.5,0)+0.99



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?


--

Dave Peterson