Your question is confusing. Are you sure wht you want to do. However, mentioned below are few suggestions which you can follow and whatever suites you best
24.79 round(24.79,0) will return 25 if you want it to return you the lowest integer before 24.79 then use INT(24.79) which will return 24 24.80 25 50 50 Regards, Sarfaraz Ahmed Excel help <http://findsarfaraz.blogspot.com/> On Thu, Jan 22, 2009 at 3:06 PM, Kamran Haider <haider_panjt...@hotmail.com>wrote: > Dear Group mates, > > Please help me on round formula as xl built in formula round the figure on > general math rule i.e 25.5 to 26 and 25.4 > to 25 whereas i want to work this formula in the way dat if i entered > figure which value after decimal sign is greater than 79 then it would round > the figure otherwise remain the same. > > > *Example* *:* > ** > Figure Result > 24.79 24 > 24.80 25 > 50 50 > > > > Allah Hafiz , > Kamran Haider . > > > > > > ------------------------------ > What can you do with the new Windows Live? Find > out<http://www.microsoft.com/windows/windowslive/default.aspx> > > > > -- Thanks with regards, Sarfaraz Ahmed --~--~---------~--~----~------------~-------~--~----~ Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To post to this group, send email to excel-macros@googlegroups.com For more options, visit this group at http://groups.google.com/group/excel-macros?hl=en Visit & Join Our Orkut Community at http://www.orkut.com/Community.aspx?cmm=22913620 To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com To see the Daily Excel Tips, Go to: http://exceldailytip.blogspot.com If you find any spam message in the group, please send an email to Ayush @ jainayus...@gmail.com -~----------~----~----~----~------~----~------~--~---
