All, I have a similar rounding situation as Michelle. I attempted the macro
you gave her, unfortunately it did not work.
I have ranges of numbers in columns B:F (I edited the macro to say B:F
instead of A:A), my numbers are not dollars and cents, just dollars. I want
them to round to the nearest 5 or 0 (I edited the macro from 0.05 to just 5).
The data is in columns/rows A3:F35 (if that makes any difference).
Here is an example of what I want to see:
184380 212040 239695 267350 295010
from:
184381 212038 239695 267352 295009
when I ran the "Michelle" macro, it changed nothing, what did I do wrong?
Or is there a better way to go about changing these ranges?
Thanks.
"Ron Rosenfeld" wrote:
On Sat, 4 Dec 2004 07:13:04 -0800, boyshanks
wrote:
Ron thanks so much for your help on this matter. I have a slightly
different rounding issue, but I don't know how to modify your macro to
achieve my needs.
WHAT I WANT:
I have a cell which contains the formula: C3/2. When that formula returns a
number such as 9.32, I want it to round DOWN to 9. When that formula returns
a number such as 9.512, I want it to round UP to 10. All in the same cell.
Can you help me with this? I did load the Data Analysis ADD IN but it is
very confusing to me.
Thanks in advance!!
In this instance, there is no need to use A VBA macro. Merely modify your
formula to:
=ROUND(C3/2,0)
--ron
|