Is there a formula to round a number to the nearest .09?

[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?

 

[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

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

 

[Tyro]

We need to know your rounding rules. What happens to 1.40, 1.41, 1.42 etc?

Tyro

 

[David Biddulph]

=ROUND(A2+0.01,1)-0.01

 

[Mike H]

There has to be a better way but try this for now

=IF(A1<>0,ROUND(A1,1)-0.01,"")

Mike

 

[Stan Brown]

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?