Hi David, Thanks for your feedback and evaluation. I've corrected and posted the solution, please check this link again to see the changes: http://www.excelitems.com/2009/03/ceiling-and-floor-function.html
For more tips, tricks, downloads and problem solutions: visit --> http://www.excelitems.com ------------------------------------------------------------------------ Regards *Ashish **Jain* Analyst and Demand-Co-ordinator, CSC Australia Microsoft Certified Application (Excel) Specialist Technical Trainer - Excel and VBA Author -> www.excelitems.com 09999-40-48-43 ---------------------------------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------- On Thu, Mar 5, 2009 at 1:28 PM, D Matic <dmma...@gmail.com> wrote: > Ashish, > Thank you so much for responding but let me ask you this. Can formula be > twiked that everything between x.51 and x.99 in C1 is rounded to x.97 and > everything between x.01 to x.49 in C1 is rounded to x.47. > > Your example shows: > 9.99 75% 2.50 2.47 25.99 60% 10.40 10.97 29.99 30% 20.99 20.47 35.99 > 25% 26.99 26.47 > > Can it be set up so it rounds to: > 9.99 75% 2.50 2.47 25.99 60% 10.40 10.47 29.99 30% 20.99 20.97 35.99 > 25% 26.99 26.97 > > Thanks, > David > > > On Wed, Mar 4, 2009 at 5:52 PM, Ashish Jain <26may.1...@gmail.com> wrote: > >> >> ---------------------------------------------------------------------------------------------------------------------------- >> >> Hi DM, >> >> I've posted your solution, please check this link: >> http://www.excelitems.com/2009/03/ceiling-and-floor-function.html >> >> >> >> >> >> For more tips, tricks, downloads and problem solutions: visit --> >> http://www.excelitems.com >> ------------------------------------------------------------------------ >> Regards >> *Ashish **Jain* >> Analyst and Demand-Co-ordinator, CSC Australia >> Microsoft Certified Application (Excel) Specialist >> Technical Trainer - Excel and VBA >> Author -> www.excelitems.com >> 09999-40-48-43 >> >> ---------------------------------------------------------------------------------------------------------------------------- >> >> ---------------------------------------------------------------------------------------------------------------------------- >> >> On Thu, Mar 5, 2009 at 4:29 AM, DM <dmma...@gmail.com> wrote: >> >>> >>> Ok, can someone help me out? I am trying to create formula that is >>> going to round my numbers to x.47 or x.97. >>> A1=$9.99 >>> B1=75% >>> C1=A1-B1=$2.49 >>> So what I am trying to do is to take discount from price and if it >>> ends x.49 I would like to round it x.47 and if it ends x.99 I would >>> like to round it to x.97. >>> >>> Does this make senseā¦.so everything between x.51 and x.99 should be >>> rounded to x.97 and everything between x.01 to x.49 should be rounded >>> to x.47. >>> >>> >>> >> >> >> -- >> Regards >> Ashish Jain >> >> >> Sent from: United States. >> >> >> > > --~--~---------~--~----~------------~-------~--~----~ > ------------------------------------------------------------------------------------- > > Some important links for excel users: > 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at > http://www.excelitems.com > 2. Excel tutorials at http://www.excel-macros.blogspot.com > 3. Learn VBA Macros at http://www.vbamacros.blogspot.com > 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > If you find any spam message in the group, please send an email to: > Ayush Jain @ jainayus...@gmail.com or > Ashish Jain @ 26may.1...@gmail.com > > ------------------------------------------------------------------------------------- > --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---