I need a formula that rounds the result of a calculation
to a number exactly divisible by 250.

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.

Patty Hatridge wrote:
I need a formula that rounds the result of a calculation
to a number exactly divisible by 250.

=ROUND(A1/250,0)*250

Assuming the number to be rounded is in A1. YOu might want to check the
name of the function (ROUND), because I use Excel in spanish (REDONDEAR).

Regards,
--
Beto
Reply: Erase between the dot (inclusive) and the @.
Responder: Borra la frase obvia y el punto previo.