LOG10 Function
The LOG function allows you to get the base 10 logarithm of a positive number. For example:
=LOG10(100) // returns 2
=LOG10(1000) // returns 3
=LOG10(0.1) // returns -1
...Read more
Dave Bruns
Round a number up to next half
The Excel CEILING function rounds a number up to a given multiple. The multiple to use for rounding is given as the second argument (significance). If the number is already an exact multiple, no rounding occurs.
In this example...Read more
Round time to nearest 15 minutes
MROUND rounds to nearest values based on a supplied multiple. When you supply "0:15" as the multiple, Excel internal converts 0:15 into 0.0104166666666667, which is the decimal value that represents 15 minutes, and rounds using that value.
You can also express 15 minutes in a formula...Read more
Round a price to end in .99
In the example shown, the goal is to round a price to the nearest value ending in .99. So, for example, if a price is currently $5.31, the result should be $4.99. The best way to think about the problem is to restate it as "round a price to the nearest whole dollar, less 1 penny". In other...Read more
Round a number down to nearest multiple
The Excel FLOOR function rounds a number down to a given multiple. The multiple to use for rounding is given as the second argument (significance). If the number is already an exact multiple, no rounding occurs. FLOOR works like the ...Read more
Round a number up to nearest multiple
The Excel CEILING function rounds a number up to a given multiple. The multiple to use for rounding is given as the second argument (significance). If the number is already an exact multiple, no rounding occurs. CEILING works like the...Read more
Round a number to nearest multiple
The MROUND function rounds a number to the nearest given multiple. The multiple to use for rounding is provided as the significance argument. If the number is already an exact multiple, no rounding occurs and the original number is returned. You...Read more
Round a number down
The ROUNDDOWN function rounds a number down to a given number of places. The number of places is controlled by the number of digits provided in the second argument (num_digits). For example, these formulas round the number 5.89 down...Read more
Round a number up
The ROUNDUP function rounds a number up to a given number of places. The number of places is controlled by the number of digits provided in the second argument (num_digits). For example, these formulas round the number 5.13 up to 1 and...Read more