Tom,
log10() can help you in this case. You can use that to get order of magnitude and then round up or down to some number of decimal places, then take 10^ that power to get your limit.
>I am writing a custom class to handle the dynamic generation of a line graph from data in a cursor. As you can imagine, I need to find the max and min values but what if they stop at an odd level?
>
>For instance what if I have a max value of 21.34. I suppose I could use the CEILING() function to raise to the next highest integer of 22 but what if instead that value was .2134 - I do not want to jump all the way up to 1.00. Even on the first example, perhaps 21.50 is a better upper limit but how can this be handled generically?