Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Is 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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Is there a formula to round a number to the nearest .09?
Would:
=ROUND(A1,1)-0.01*(A10.04) do what you want? If A1 will never be under 0.05 then you can miss off the *(A10.04) part -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "WenMess" wrote in message ... 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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Is there a formula to round a number to the nearest .09?
We need to know your rounding rules. What happens to 1.40, 1.41, 1.42 etc?
Tyro "WenMess" wrote in message ... 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? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Is there a formula to round a number to the nearest .09?
=ROUND(A2+0.01,1)-0.01
-- David Biddulph "WenMess" wrote in message ... 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? |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Is there a formula to round a number to the nearest .09?
There has to be a better way but try this for now
=IF(A1<0,ROUND(A1,1)-0.01,"") Mike "WenMess" wrote: 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? |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Is there a formula to round a number to the nearest .09?
Fri, 1 Feb 2008 12:11:14 -0800 from WenMess
: 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? -- Stan 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Round a number to the Nearest .25 | Excel Worksheet Functions | |||
How do I round a 4 digits number to it's nearest 10 | Excel Worksheet Functions | |||
want to round a number to the nearest quarter 0.25-0.50-0.45-0.00 | Excel Worksheet Functions | |||
How do I round a number to the nearest 600 in Excel? | Excel Worksheet Functions | |||
How can I round a number to the nearest "50" or "100" in excel 200 | Excel Worksheet Functions |