Enter a formula in cell d5 to calculate b5/b4 rounded to 4 decimal places.

Click in cell D5.
Then use this formula:
=round(B5/B4, 4)

Example:
b4 = 3.2165
b5 = 21.43
In cell d5, type =round(b5/b4) and press Enter.
cell d5 contains 6.6625.

Answer:
=round(b5/b4, 4)

Answer Link

MrRoyal MrRoyal · Answer 2 · 2022-02-21T14:15:29+01:00

Excel formulas are expressions used to perform computation.

The Excel formula to enter in cell D5 is = ROUND(B5/B4, 4)

From the question, we have:

The formula in cell D5 is the quotient of cells B5 and B4
The result is to be approximated to 4 decimal places

The quotient of cells B5 and B4 is represented as:

B5/B4

To round the quotient, we make use of the ROUND function

So, we have:

ROUND(B5/B4, 4)

Excel formulas begin with the "=" sign

This gives

= ROUND(B5/B4, 4)

Hence, the Excel formula to enter in cell D5 is = ROUND(B5/B4, 4)