ExcelBanter - Round up to 100?

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

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

- - Round up to 100? (https://www.excelbanter.com/excel-worksheet-functions/14232-round-up-100-a.html)

Fred Holmes

Round up to 100?

I'm trying to construct a worksheed formula that will round up to the
nearest 100.

f(26,335.37) = 26,400.00

JE McGimpsey

One way:

=CEILING(A1,100)

Another:

=ROUNDUP(A1,-2)

In article ,
Fred Holmes wrote:

I'm trying to construct a worksheed formula that will round up to the
nearest 100.

f(26,335.37) = 26,400.00

All times are GMT +1. The time now is 06:01 AM.