ExcelBanter - Formula for rounding a column of currency to a multiple

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Formula for rounding a column of currency to a multiple (https://www.excelbanter.com/excel-worksheet-functions/83210-formula-rounding-column-currency-multiple.html)

GenoBambino

Formula for rounding a column of currency to a multiple

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

CLR

Formula for rounding a column of currency to a multiple

=CEILING(A1,0.05)

Vaya con Dios,
Chuck, CABGx3

"GenoBambino" wrote in message
...
Can anyone tell me the formula for rounding a column of currency up to the
nearest nickel? Thanks

All times are GMT +1. The time now is 10:33 AM.