Scribd
Upload
2 views1 page

Live Result Rounding Examples

The document describes the CEILING function in Excel, which rounds a number up to the nearest multiple of a specified value. It provides examples of rounding 2.5, -2.5, 1.5, and 0.234 up to the nearest multiple of 1, -2, 0.1, and 0.01 respectively, and shows the resulting values.

Uploaded by

Shraddha Tiwari
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
2 views1 page

Live Result Rounding Examples

The document describes the CEILING function in Excel, which rounds a number up to the nearest multiple of a specified value. It provides examples of rounding 2.5, -2.5, 1.5, and 0.234 up to the nearest multiple of 1, -2, 0.1, and 0.01 respectively, and shows the resulting values.

Uploaded by

Shraddha Tiwari
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

Formula Description Live Result

Rounds 2.5 up to nearest multiple


=CEILING(2.5, 1) of 1 3
Rounds -2.5 up to nearest multiple
=CEILING(-2.5, -2) of -2 -4
Rounds -2.5 up to nearest multiple
=CEILING(-2.5, 2) of 2 -2
Rounds 1.5 up to the nearest
=CEILING(1.5, 0.1) multiple of 0.1 1.5
Rounds 0.234 up to the nearest
=CEILING(0.234, 0.01) multiple of 0.01 0.24

You might also like