formula for rounding
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.
|