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?

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?

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?

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?

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?

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/