Roundup Nesting

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
John said:
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
Click to expand...

John

You posted this message in an XP support group. Try one of the many Excel
groups.

news://msnews.microsoft.com/microsoft.public.excel.newusers
 
Thanks Ronnie
I'll mark as question answered. hopefully that will get this out of the group.
jfs
 
Back
Top