View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Beto[_3_] Beto[_3_] is offline
external usenet poster
 
Posts: 140
Default 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.