Which formula in cell D5 calculates B5 divided by B4 and rounds the result to four decimal places?

Which formula in cell D5 calculates B5 divided by B4 and rounds the result to four decimal places?

• A. =ROUND(B5/B4, 2)
• B. =ROUND(B5/B4, 4)
• C. =ROUNDDOWN(B5/B4, 4)
• D. =ROUNDUP(B5/B4, 4)

Answer: (B)

Rounding the result of a division to a specific number of decimal places using the ROUND function. To divide B5 by B4 and round to four decimal places, place the division inside ROUND and specify 4 as the second argument: ROUND(B5/B4, 4). The first argument is the value to round (the quotient B5/B4), and the second argument indicates how many digits to keep to the right of the decimal. This choice rounds in the standard way to four decimals. Other options either limit to fewer decimals or use different rounding behaviors: ROUND(B5/B4, 2) would yield two decimals, ROUNDDOWN(B5/B4, 4) truncates after four decimals, and ROUNDUP(B5/B4, 4) always rounds up.

Rounding the result of a division to a specific number of decimal places using the ROUND function. To divide B5 by B4 and round to four decimal places, place the division inside ROUND and specify 4 as the second argument: ROUND(B5/B4, 4). The first argument is the value to round (the quotient B5/B4), and the second argument indicates how many digits to keep to the right of the decimal.

This choice rounds in the standard way to four decimals. Other options either limit to fewer decimals or use different rounding behaviors: ROUND(B5/B4, 2) would yield two decimals, ROUNDDOWN(B5/B4, 4) truncates after four decimals, and ROUNDUP(B5/B4, 4) always rounds up.