Round to 50 or 100

[newtexas2006]

I want to round the money to 50 or close 100. example 645=>650 765.20=>750 893.34=>900

I use spread sheet, so I don't have fancy feature like ROUNDUP or ROUNDDOWN.... only ROUND feature.

Thanks

[VBA Noob]

If you got the CEILING function try

=CEILING(A1,50)

otherwise

=ROUND(A1/50,0)*50

VBA Noob

[avveerkar]

One more option using simple function INT which returns integer part of a number

Please Login or Register  to view this content.

A V Veerkar