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
