Formula for rounding a column of currency to a multiple

GenoBambino · Apr 14, 2006

Can anyone tell me the formula for rounding a column of currency up to the
nearest nickel? Thanks

CLR · Apr 14, 2006

=CEILING(A1,0.05)

Vaya con Dios,
Chuck, CABGx3