|
Pricing - how to round up various prices to .95
I have various prices / 5.26, 2.14, 16.58 that I want to round up to the next
..95 so they will be 5.95, 2.95, 16.95. Is there an automated way to do this? Thank you. -- MikeB94518 |
Hi, Mike. I always do it this way: Round up to the nearest dollar, then
subtract a nickel. Like: =roundup(a1,0)-.05 ******************* ~Anne Troy www.OfficeArticles.com "MikeB94518" wrote in message ... I have various prices / 5.26, 2.14, 16.58 that I want to round up to the next .95 so they will be 5.95, 2.95, 16.95. Is there an automated way to do this? Thank you. -- MikeB94518 |
one way?
=INT(C12)+1-0.05 -- Don Guillett SalesAid Software "MikeB94518" wrote in message ... I have various prices / 5.26, 2.14, 16.58 that I want to round up to the next .95 so they will be 5.95, 2.95, 16.95. Is there an automated way to do this? Thank you. -- MikeB94518 |
=INT(A1)+0.95+(MOD(A1,1)0.95)
hence 1.96 will become 2.95 ; the next round up number ending in .95 if you want it to be 1.95 instead simply remove the mod part of the formula "MikeB94518" wrote in message ... I have various prices / 5.26, 2.14, 16.58 that I want to round up to the next .95 so they will be 5.95, 2.95, 16.95. Is there an automated way to do this? Thank you. -- MikeB94518 |
Thank you. So, if my price of 10.45 is in cell b5 (coming from a formula
a5*1.5), and I want it to go to 10.95, how do I do the formula? would it be =b5........? Thank you -- MikeB94518 "Anne Troy" wrote: Hi, Mike. I always do it this way: Round up to the nearest dollar, then subtract a nickel. Like: =roundup(a1,0)-.05 ******************* ~Anne Troy www.OfficeArticles.com "MikeB94518" wrote in message ... I have various prices / 5.26, 2.14, 16.58 that I want to round up to the next .95 so they will be 5.95, 2.95, 16.95. Is there an automated way to do this? Thank you. -- MikeB94518 |
thank you. If my number 10.45 is in cell b5, coming from a formula b4*1.5,
how do I do the formula? =b5.....? thank you -- MikeB94518 "Don Guillett" wrote: one way? =INT(C12)+1-0.05 -- Don Guillett SalesAid Software "MikeB94518" wrote in message ... I have various prices / 5.26, 2.14, 16.58 that I want to round up to the next .95 so they will be 5.95, 2.95, 16.95. Is there an automated way to do this? Thank you. -- MikeB94518 |
Don,
No not "Down under" I am from NJ and try sneaking in once in a while at this newsgroup here at work, trying to hone my excel skills "Don Guillett" wrote in message ... As usual, better than mine. How are things "down under"? -- Don Guillett SalesAid Software "N Harkawat" <nharkawat@hotmail_dot_com wrote in message ... =INT(A1)+0.95+(MOD(A1,1)0.95) hence 1.96 will become 2.95 ; the next round up number ending in .95 if you want it to be 1.95 instead simply remove the mod part of the formula "MikeB94518" wrote in message ... I have various prices / 5.26, 2.14, 16.58 that I want to round up to the next .95 so they will be 5.95, 2.95, 16.95. Is there an automated way to do this? Thank you. -- MikeB94518 |
Mike, seems everyone thinks you should know what to do to incorporate their
suggestions into your formula.<g If B5 contains the formula: =B4*1.5 Then, depending on whose suggestion you care to use, try either of these in B5: =ROUNDUP(B4*1.5,0)-.05 =INT(B4*1.5)+1-0.05 =INT(B4*1.5)+0.95+(MOD(B4*1.5,1)0.95) -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "MikeB94518" wrote in message ... thank you. If my number 10.45 is in cell b5, coming from a formula b4*1.5, how do I do the formula? =b5.....? thank you -- MikeB94518 "Don Guillett" wrote: one way? =INT(C12)+1-0.05 -- Don Guillett SalesAid Software "MikeB94518" wrote in message ... I have various prices / 5.26, 2.14, 16.58 that I want to round up to the next .95 so they will be 5.95, 2.95, 16.95. Is there an automated way to do this? Thank you. -- MikeB94518 |
Well...some of us from PA might call NJ "down under". ROFL!!
******************* ~Anne Troy www.OfficeArticles.com "N Harkawat" <nharkawat@hotmail_dot_com wrote in message ... Don, No not "Down under" I am from NJ and try sneaking in once in a while at this newsgroup here at work, trying to hone my excel skills "Don Guillett" wrote in message ... As usual, better than mine. How are things "down under"? -- Don Guillett SalesAid Software "N Harkawat" <nharkawat@hotmail_dot_com wrote in message ... =INT(A1)+0.95+(MOD(A1,1)0.95) hence 1.96 will become 2.95 ; the next round up number ending in .95 if you want it to be 1.95 instead simply remove the mod part of the formula "MikeB94518" wrote in message ... I have various prices / 5.26, 2.14, 16.58 that I want to round up to the next .95 so they will be 5.95, 2.95, 16.95. Is there an automated way to do this? Thank you. -- MikeB94518 |
Sorry, Had you confused with someone else. For you, TEXAS (where I am), is
"down under" -- Don Guillett SalesAid Software "N Harkawat" <nharkawat@hotmail_dot_com wrote in message ... Don, No not "Down under" I am from NJ and try sneaking in once in a while at this newsgroup here at work, trying to hone my excel skills "Don Guillett" wrote in message ... As usual, better than mine. How are things "down under"? -- Don Guillett SalesAid Software "N Harkawat" <nharkawat@hotmail_dot_com wrote in message ... =INT(A1)+0.95+(MOD(A1,1)0.95) hence 1.96 will become 2.95 ; the next round up number ending in .95 if you want it to be 1.95 instead simply remove the mod part of the formula "MikeB94518" wrote in message ... I have various prices / 5.26, 2.14, 16.58 that I want to round up to the next .95 so they will be 5.95, 2.95, 16.95. Is there an automated way to do this? Thank you. -- MikeB94518 |
| All times are GMT +1. The time now is 10:25 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com