February 1, 2023
Microsoft Excel offers hundreds of functions. So, there’s bound to be at least a handful you don’t know exist. These unique functions have specific purposes that you’ll be thrilled to learn about and use. RELATED: 12 Basic Excel Functions Everybody Should Know FLOOR and CEILING for Rounding You can use the FLOOR and CEILING math…

Microsoft Excel offers hundreds of functions. So, there’s bound to be at least a handful you don’t know exist. These unique functions have specific purposes that you’ll be thrilled to learn about and use.

RELATED: 12 Basic Excel Functions Everybody Should Know

FLOOR and CEILING for Rounding

You can use the FLOOR and CEILING math functions for rounding towards or away from zero by a specified multiple. Use FLOOR to round down and CEILING to round up.

The syntax for each is FLOOR(value, multiple) and CEILING(value, multiple) where both arguments are required.

To round 4.4 down to the nearest multiple of 2, you’d use the following formula:

=FLOOR(4.4,2)

To round 5.6 up to the nearest multiple of 2, you’d use this formula:

=CEILING(5.6,2)

MODE.SNGL for Finding Repetitive Values

Originally simply the MODE function, Microsoft created a newer version of this statistical function for improved accuracy. Use MODE.SNGL to find a single frequently recurring number in an array or cell range.

The…

Read Full Article Source