Rewriting equation for VB

[Guest]

I have the following equation

.MaximumScale = 5 * RoundUp((Max / 5) / (10 ^ (Len((Max / 5)) -
1)), 0) * (10 ^ (Len((Max / 5)) - 1))


Max is a value that's previously been determined and the formula are the
Excel equivalents. How do I rewrite this so that it's evaluated
programmatically?

Thanks in advance,
Barb Reinhardt

 

[Guest]

This? Or have I missed something?

MaximumScale = 5 * Application.RoundUp((Max / 5) / (10 ^ (Len((Max / 5)) -
1)), 0) * (10 ^ (Len((Max / 5)) - 1))

 

[Tom Ogilvy]

Think you would need the second argument to roundup as well.