Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Formula to round off number to .95 cents
598 views
Skip to first unread message
Pat
Oct 12, 2009, 1:29:01 PM10/12/09
to
I'm having trouble writing a formula to round off my results to .95 cents.
I take the cost of my prodcut and mark it up, say double, 200%.
I take $10.25 *200%=$20.50, I would like to round the off cents to .95
I take the cost of my prodcut and mark it up, say double, 200%.
I take $10.25 *200%=$20.50, I would like to round the off cents to .95
Your help is greatly apperciated.
--
Pat D.
Jacob Skaria
Oct 12, 2009, 1:37:03 PM10/12/09
to
=ROUND(10.25*200%,0)-0.05
OR
=ROUNDUP(10.25*200%,)-0.05
OR
=ROUNDUP(10.25*200%,)-0.05
If this post helps click Yes
---------------
Jacob Skaria
Ms-Exl-Learner
Oct 12, 2009, 1:41:02 PM10/12/09
to
Try this...
=ROUND(10.25*200%,0)
=ROUND(A1,0)
Otherwise format the cell Currency decimal places as 0.
If this post helps, Click Yes!
--------------------
(Ms-Exl-Learner)
--------------------
Pat
Oct 12, 2009, 1:51:05 PM10/12/09
to
Thank kindly, it works great.
--
Pat D.
--
Pat D.
0 new messages