Yes Mr paul you r right problem is as you described it .Its good to see very experienced and helpy members .I would like to thanks to this group owner that provide us chance to meet such experience persons.Allah Hafiz ,Kamran Haider .
Date: Fri, 23 Jan 2009 08:29:51 -0800From: schreiner_p...@att.netsubject: $$Excel-Macros$$ Re: Round figureTo: excel-macros@googlegroups.com You're welcome. I think the problem is/was in understanding that "normal" rounding is done at 1/2. 1.50 rounds to 2, but 1.49999 rounds to 1. YOU, however wanted the rounding point to be .8 So, the solution was to have excel shift the number by .3 to allow Excel to use the standard rounding functions. It's actually a basic rounding problem that I encountered in a FORTRAN class 30 years ago! Some truths are forever! good luck, Paul From: Kamran Haider <haider_panjt...@hotmail.com>To: vba <excel-macros@googlegroups.com>Sent: Thursday, January 22, 2009 11:59:34 PMSubject: $$Excel-Macros$$ Re: Round figure Thanks to every one who help me on below issue though every one has the unique way that realy add my knowledge. Mr Paul thanks a lot your solution absolutely solve my problem .Allah Hafiz ,Kamran Haider . Date: Thu, 22 Jan 2009 05:41:36 -0800From: schreiner_p...@att.netsubject: $$Excel-Macros$$ Re: Round figureTo: excel-macros@googlegroups.com You should be able to use: =ROUND(A1-0.3,0)Paul From: Kamran Haider <haider_panjt...@hotmail.com>To: vba <excel-macros@googlegroups.com>Sent: Thursday, January 22, 2009 4:36:11 AMSubject: $$Excel-Macros$$ Round figure 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 2424.80 2550 50 Allah Hafiz ,Kamran Haider . What can you do with the new Windows Live? Find out _________________________________________________________________ Drag n’ drop—Get easy photo sharing with Windows Live™ Photos. http://www.microsoft.com/windows/windowslive/photos.aspx --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
