Cost vs retail
"cochum" wrote:
"Dave Peterson" wrote:
cochum wrote:
So I want everthing to have a 50% mark up,
but to always end the retail in a .99 ending.
Maybe...
=ROUNDUP(A1*1.5,0)+0.99
Thanks this one worked perfect!
If by "works", you mean that it produces an answer
with ".99" at the end, I would agree. But I believe
it gives the wrong answer in most cases. By "wrong",
I mean that result will be slightly higher than necessary.
Of course, you might not care, since it merely mean
more profit. But I believe the "correct" answer is
ROUNDDOWN, not ROUNDUP.
Proof: If 1.5*R is ccc.99, ROUNDDOWN()+0.99 with
result in ccc.99. Otherwise, 1.5*R is less than ccc.99,
and ROUNDDOWN()+0.99 results in 1.5*R rounded up
to ".99".
Note: I believe that is also true for ROUNDIP()-0.01,
which someone else suggested.
In contrast, ROUNDUP()+0.99 results in 1.00+ccc.99
-- that is, an extract $1 -- in all cases where 1.5*R is
ccc.01 or more.
|