Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Overflow/underflow if statement wrapped around an if statement

Avatar

Level 1

I am getting the overflow/underflow error due to a calculation trying to divide by zero, but am not enough of a scripter to be able to figure out how to make the if (x > 0) statement work with the current script in the cell which is:

if (form1.BudgetSummarypage20.Table7.Row1.Cell3/form1.BudgetSummarypage20.Table7.Row5.Cell2 <.5) then 0 elseif (form1.BudgetSummarypage20.Table7.Row1.Cell3/Row5.Cell2 > .5) then (form1.BudgetSummarypage20.Table7.Row1.Cell3/form1.BudgetSummarypage20.Table7.Row5.Cell2) else 0 endif

the cell that needs to be checked for zero is form1.BudgetSummarypage20.Table7.Row5.Cell2

Hopefully this is easy as pie for one of you.  Your help is greatly appreciated.

0 Replies