software

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?

Maybe...

=ROUNDUP(A1*1.5,0) 0.99
cochum wrote:
gt;
gt; I am creating a spread sheet to make marking up cost easier and standard.
gt; The only thing is that I want to always have a .99 cent ending ont he retail.
gt; So I want everthing to have a 50% mark up, but to always end the retail in a
gt; .99 ending. How do I do that?

--

Dave Peterson

Will this work:

=ROUNDUP((A1*1.5),0)-0.01

Change A1 to match your cell reference.

HTH,
Elkar

quot;cochumquot; wrote:

gt; I am creating a spread sheet to make marking up cost easier and standard.
gt; The only thing is that I want to always have a .99 cent ending ont he retail.
gt; So I want everthing to have a 50% mark up, but to always end the retail in a
gt; .99 ending. How do I do that?

Thanks this one worked perfect!

quot;Dave Petersonquot; wrote:

gt; Maybe...
gt;
gt; =ROUNDUP(A1*1.5,0) 0.99
gt;
gt;
gt;
gt; cochum wrote:
gt; gt;
gt; gt; I am creating a spread sheet to make marking up cost easier and standard.
gt; gt; The only thing is that I want to always have a .99 cent ending ont he retail.
gt; gt; So I want everthing to have a 50% mark up, but to always end the retail in a
gt; gt; .99 ending. How do I do that?
gt;
gt; --
gt;
gt; Dave Peterson
gt;

quot;cochumquot; wrote:
gt; quot;Dave Petersonquot; wrote:
gt; gt; cochum wrote:
gt; gt; gt; So I want everthing to have a 50% mark up,
gt; gt; gt; but to always end the retail in a .99 ending.
gt; gt;
gt; gt; Maybe...
gt; gt; =ROUNDUP(A1*1.5,0) 0.99
gt;
gt; Thanks this one worked perfect!

If by quot;worksquot;, you mean that it produces an answer
with quot;.99quot; at the end, I would agree. But I believe
it gives the wrong answer in most cases. By quot;wrongquot;,
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 quot;correctquot; 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 quot;.99quot;.

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.

I agree with you.

And with an example:

Cost is 1.00:
=ROUNDUP(A1*1.5,0) 0.99 returns 2.99
=ROUNDUP((A1*1.5),0)-0.01 returns 1.99
=ROUNDDOWN(A1*1.5,0) 0.99 returns 1.99

Cost is 2.00:
=ROUNDUP(A1*1.5,0) 0.99 returns 3.99
=ROUNDUP((A1*1.5),0)-0.01 returns 2.99
=ROUNDDOWN(A1*1.5,0) 0.99 returns 3.99

So the only formula that really works is the =rounddown() version.

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

--

Dave Peterson

I came back and already fixed it but thanks too you both!
Don't suppose either of you know how I would add a button that when clicked
would change the control numbers in a cell?

quot;Dave Petersonquot; wrote:

gt; I agree with you.
gt;
gt; And with an example:
gt;
gt; Cost is 1.00:
gt; =ROUNDUP(A1*1.5,0) 0.99 returns 2.99
gt; =ROUNDUP((A1*1.5),0)-0.01 returns 1.99
gt; =ROUNDDOWN(A1*1.5,0) 0.99 returns 1.99
gt;
gt; Cost is 2.00:
gt; =ROUNDUP(A1*1.5,0) 0.99 returns 3.99
gt; =ROUNDUP((A1*1.5),0)-0.01 returns 2.99
gt; =ROUNDDOWN(A1*1.5,0) 0.99 returns 3.99
gt;
gt; So the only formula that really works is the =rounddown() version.
gt;
gt; Here's hoping the OP comes back.
gt;
gt;
gt;
gt;
gt; wrote:
gt; gt;
gt; gt; quot;cochumquot; wrote:
gt; gt; gt; quot;Dave Petersonquot; wrote:
gt; gt; gt; gt; cochum wrote:
gt; gt; gt; gt; gt; So I want everthing to have a 50% mark up,
gt; gt; gt; gt; gt; but to always end the retail in a .99 ending.
gt; gt; gt; gt;
gt; gt; gt; gt; Maybe...
gt; gt; gt; gt; =ROUNDUP(A1*1.5,0) 0.99
gt; gt; gt;
gt; gt; gt; Thanks this one worked perfect!
gt; gt;
gt; gt; If by quot;worksquot;, you mean that it produces an answer
gt; gt; with quot;.99quot; at the end, I would agree. But I believe
gt; gt; it gives the wrong answer in most cases. By quot;wrongquot;,
gt; gt; I mean that result will be slightly higher than necessary.
gt; gt; Of course, you might not care, since it merely mean
gt; gt; more profit. But I believe the quot;correctquot; answer is
gt; gt; ROUNDDOWN, not ROUNDUP.
gt; gt;
gt; gt; Proof: If 1.5*R is ccc.99, ROUNDDOWN() 0.99 with
gt; gt; result in ccc.99. Otherwise, 1.5*R is less than ccc.99,
gt; gt; and ROUNDDOWN() 0.99 results in 1.5*R rounded up
gt; gt; to quot;.99quot;.
gt; gt;
gt; gt; Note: I believe that is also true for ROUNDIP()-0.01,
gt; gt; which someone else suggested.
gt; gt;
gt; gt; In contrast, ROUNDUP() 0.99 results in 1.00 ccc.99
gt; gt; -- that is, an extract $1 -- in all cases where 1.5*R is
gt; gt; ccc.01 or more.
gt;
gt; --
gt;
gt; Dave Peterson
gt;

how I would add a button that when clicked
gt; would change the control numbers in a cell?

you will need to be a wee bit more specific than that...do you want say a
dropdown box(es) to select markups and or rounding ammounts,ie 95 55 etc....
--
paul
remove nospam for email addy!
quot;cochumquot; wrote:

gt; I came back and already fixed it but thanks too you both!
gt; Don't suppose either of you know how I would add a button that when clicked
gt; would change the control numbers in a cell?
gt;
gt; quot;Dave Petersonquot; wrote:
gt;
gt; gt; I agree with you.
gt; gt;
gt; gt; And with an example:
gt; gt;
gt; gt; Cost is 1.00:
gt; gt; =ROUNDUP(A1*1.5,0) 0.99 returns 2.99
gt; gt; =ROUNDUP((A1*1.5),0)-0.01 returns 1.99
gt; gt; =ROUNDDOWN(A1*1.5,0) 0.99 returns 1.99
gt; gt;
gt; gt; Cost is 2.00:
gt; gt; =ROUNDUP(A1*1.5,0) 0.99 returns 3.99
gt; gt; =ROUNDUP((A1*1.5),0)-0.01 returns 2.99
gt; gt; =ROUNDDOWN(A1*1.5,0) 0.99 returns 3.99
gt; gt;
gt; gt; So the only formula that really works is the =rounddown() version.
gt; gt;
gt; gt; Here's hoping the OP comes back.
gt; gt;
gt; gt;
gt; gt;
gt; gt;
gt; gt; wrote:
gt; gt; gt;
gt; gt; gt; quot;cochumquot; wrote:
gt; gt; gt; gt; quot;Dave Petersonquot; wrote:
gt; gt; gt; gt; gt; cochum wrote:
gt; gt; gt; gt; gt; gt; So I want everthing to have a 50% mark up,
gt; gt; gt; gt; gt; gt; but to always end the retail in a .99 ending.
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; Maybe...
gt; gt; gt; gt; gt; =ROUNDUP(A1*1.5,0) 0.99
gt; gt; gt; gt;
gt; gt; gt; gt; Thanks this one worked perfect!
gt; gt; gt;
gt; gt; gt; If by quot;worksquot;, you mean that it produces an answer
gt; gt; gt; with quot;.99quot; at the end, I would agree. But I believe
gt; gt; gt; it gives the wrong answer in most cases. By quot;wrongquot;,
gt; gt; gt; I mean that result will be slightly higher than necessary.
gt; gt; gt; Of course, you might not care, since it merely mean
gt; gt; gt; more profit. But I believe the quot;correctquot; answer is
gt; gt; gt; ROUNDDOWN, not ROUNDUP.
gt; gt; gt;
gt; gt; gt; Proof: If 1.5*R is ccc.99, ROUNDDOWN() 0.99 with
gt; gt; gt; result in ccc.99. Otherwise, 1.5*R is less than ccc.99,
gt; gt; gt; and ROUNDDOWN() 0.99 results in 1.5*R rounded up
gt; gt; gt; to quot;.99quot;.
gt; gt; gt;
gt; gt; gt; Note: I believe that is also true for ROUNDIP()-0.01,
gt; gt; gt; which someone else suggested.
gt; gt; gt;
gt; gt; gt; In contrast, ROUNDUP() 0.99 results in 1.00 ccc.99
gt; gt; gt; -- that is, an extract $1 -- in all cases where 1.5*R is
gt; gt; gt; ccc.01 or more.
gt; gt;
gt; gt; --
gt; gt;
gt; gt; Dave Peterson
gt; gt;