temp = x mod 250
if(temp<250/2)
res = x-temp
else
res = x + (250-temp)
mod is a standard arithmetic operator that returns the remainder of x
divided by y. not sure what the syntax is for
VB in most other languages
it's % or 'mod'.
"Patty Hatridge" wrote in message
...
I need a formula that rounds the result of a calculation
to a number exactly divisible by 250.