ExcelBanter - Rounding

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

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

- - Rounding (https://www.excelbanter.com/excel-worksheet-functions/65901-rounding.html)

Richard

Rounding

I need to round each of the numbers in a column UP to the nearest .25
(quarter). Who can help?

vezerid

Rounding

=CEILING(A1, 0.25)

HTH
Kostis Vezerides

All times are GMT +1. The time now is 05:49 AM.