W
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?
formula/function that would do this?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
S
Sandy Mann
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
--
HTH
Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings
[email protected]
Replace @mailinator.com with @tiscali.co.uk
=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
--
HTH
Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings
[email protected]
Replace @mailinator.com with @tiscali.co.uk
T
Tyro
We need to know your rounding rules. What happens to 1.40, 1.41, 1.42 etc?
Tyro
Tyro
D
David Biddulph
=ROUND(A2+0.01,1)-0.01
M
Mike H
There has to be a better way but try this for now
=IF(A1<>0,ROUND(A1,1)-0.01,"")
Mike
=IF(A1<>0,ROUND(A1,1)-0.01,"")
Mike
S
Stan Brown
Fri, 1 Feb 2008 12:11:14 -0800 from WenMess
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?
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?