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

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

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

Mike H

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

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

Mike
 
S

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?
Click to expand...

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Rounding Time to Nearest 5 Minutes 1
Round Question 3
Round Function 5
Rounding to nearest 250 by 125s 3
Alternate Rounding Up & Down of .50 in a column 5
rounding up to the nearest 1000 1
Rounding numbers up or down in same formula 6
Round numbers to get to the nearest 0.09 7

Top