We raised a $20m Series A led by Coatue + Accel! Click here to read the announcement.

Excel Guides

There are a few ways to establish a FLOOR and CEILING in Excel. One way is to use the =FLOOR(number, significance) and =CEILING(number, significance) functions. For example, if you wanted to round the number 456.789 down to the nearest hundred, you would use the =FLOOR(456.789, 100) function, which would give you the result 400. If you wanted to round the number 456.789 up to the nearest hundred, you would use the =CEILING(456.789, 100) function, which would give you the result 500.

Another way to establish a FLOOR and CEILING in Excel is to use the =ROUNDDOWN(number, num_digits) and =ROUNDUP(number, num_digits) functions. For example, if you wanted to round the number 456.789 down to the nearest hundred, you would use the =ROUNDDOWN(456.789, 2) function, which would give you the result 400. If you wanted to round the number 456.789 up to the nearest hundred, you would use the =ROUNDUP(456.789, 2) function, which would give you the result 500.

You can also use the =MROUND(number, multiple) function to establish a FLOOR and CEILING in Excel. For example, if you wanted to round the number 456.789 down to the nearest hundred, you would use the =MROUND(456.789, 100) function, which would give you the result 400. If you wanted to round the number 456.789 up to the nearest hundred, you would use the =MROUND(456.789,-100) function, which would give you the result 500.

Get started with Causal today.

Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.

Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.