Thread: Roundup Nesting
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
John F[_2_] John F[_2_] is offline
external usenet poster
 
Posts: 24
Default Roundup Nesting

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