531,778 views
17 votes
17 votes
in cell B5 create a formula using round function that rounds the value in cell G19 to an integer, with 0 decimal places

User Twxia
by
2.1k points

1 Answer

13 votes
13 votes

Answer:

=ROUND(G19, 0)

Step-by-step explanation:

In Microsoft Excel you would need to click on cell B5 and then click the function bar at the top and paste the following formula

=ROUND(G19, 0)

This formula will grab whatever value is in cell G19 and round it to the nearest whole integer without any decimal places at all. This is handled by the ROUND() method which takes in two arguments, the first is the cell which has the value to be rounded, and the second argument is the number of decimal places to round to. 0 indicates no decimal places.

User Felix Seele
by
2.3k points