Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Rewriting equation for VB
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Rewriting equation for VB
This? Or have I missed something?
MaximumScale = 5 * Application.RoundUp((Max / 5) / (10 ^ (Len((Max / 5)) - 1)), 0) * (10 ^ (Len((Max / 5)) - 1)) "Barb Reinhardt" wrote: 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Rewriting equation for VB
Think you would need the second argument to roundup as well.
-- Regards, Tom Ogilvy "Toppers" wrote in message ... This? Or have I missed something? MaximumScale = 5 * Application.RoundUp((Max / 5) / (10 ^ (Len((Max / 5)) - 1)), 0) * (10 ^ (Len((Max / 5)) - 1)) "Barb Reinhardt" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SAVING AND REWRITING CHARTS | Charts and Charting in Excel | |||
Need help rewriting a macro | Excel Worksheet Functions | |||
Rewriting a formula... | Excel Discussion (Misc queries) | |||
Equation Editor- problem when editing an equation | Excel Discussion (Misc queries) | |||
Which is the best language for rewriting code into DLL's ? | Excel Programming |