In the example, cell C6 contains this formula:
=ROUND(B6,-3)
The value in B6 is 1,234,567 and the result is 1,235,000.
With the ROUND function, negative numbers for the second argument round to the left of the decimal and positive...Read more
In this example, the goal is to round a number to a given number of significant figures while preserving trailing zeros when needed. This is a tricky problem because Excel's rounding functions return numbers, and numbers don't preserve trailing zeros....Read more
LOG10 returns the base-10 logarithm of a number. In simple terms, it answers the question: "10 raised to what power gives me this number?" The table below shows how LOG10 works and how it is related to raising 10 to a specific power:
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
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
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
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
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
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