 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Worksheet Functions / February 2008Is there a formula to round a number to the nearest .09?
I'm trying to round to the nearest .09 (i.e., 1.46 would be 1.49). Is there a formula/function that would do this? Would: =ROUND(A1,1)-0.01*(A1>0.04) do what you want? If A1 will never be under 0.05 then you can miss off the *(A1>0.04) part  SignatureHTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings sandymann2@mailinator.com Replace @mailinator.com with @tiscali.co.uk > I'm trying to round to the nearest .09 (i.e., 1.46 would be 1.49). Is > there a > formula/function that would do this? We need to know your rounding rules. What happens to 1.40, 1.41, 1.42 etc? Tyro > I'm trying to round to the nearest .09 (i.e., 1.46 would be 1.49). Is > there a > formula/function that would do this? =ROUND(A2+0.01,1)-0.01 SignatureDavid Biddulph > I'm trying to round to the nearest .09 (i.e., 1.46 would be 1.49). Is > there a > formula/function that would do this? There has to be a better way but try this for now =IF(A1<>0,ROUND(A1,1)-0.01,"") Mike > I'm trying to round to the nearest .09 (i.e., 1.46 would be 1.49). Is there a > formula/function that would do this? Fri, 1 Feb 2008 12:11:14 -0800 from WenMess <WenMess@discussions.microsoft.com>: > I'm trying to round to the nearest .09 (i.e., 1.46 would be 1.49). Is there a > formula/function that would do this? Please explain more about what you are trying to do. "The nearest .09", taken literally, would mean to the nearest of 0.09, 0.18, 0.27, etc., but it's clear that you don't mean that. Do you mean the nearest two-digit decimal that ends in a 9? How do you want your formula to round 1? 1.4? 1.04? SignatureStan Brown, Oak Road Systems, Tompkins County, New York, USA http://OakRoadSystems.com/ "If there's one thing I know, it's men. I ought to: it's been my life work." -- Marie Dressler, in /Dinner at Eight/ |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.