Frank, you're a genius.
Plain and simple is the way I like it.
Unfortunately, I can't "read" it, but I will work away at that.

However, I did overlooked 2 things.
1: Negative numbers should follow the same type of rounding
2: If NO numbers in certain cells in column J, can the result in K
Show as blank?

"Frank Kabel" wrote:

Hi
maybe without a macro. Use the following formula in K1
=ROUNDUP(J1,1-(J110)-(J11000))
and copy this down for all rows

--
Regards
Frank Kabel
Frankfurt, Germany

"John F" schrieb im Newsbeitrag
...
John F wrote:
Help !! Another novice.
Excel 2003

Looking to nest 3 roundup statements.

While in cell K?, look to Cell J? ( one cell to left)
If J? <= 10.00, Roundup (J?,1)
If J? 10.00 and <= 1,000.00, Roundup (J?,0)
If J? 1,000.00, Roundup (J?,-1)

To make it more interesting, the nested instructions
should then "loop", to operate in each "K?" cell,
to end of file.

How would it define what is the end of the file?, as
there are a number of (sets of) blank cells that it
will have to "process" within the coloumn.

I hope to set up the final macro on a button
I just did one for a footer macro I made.

I hope this is enough detail for someone to help me out.
Thanks in advance.

John F. Scholten