Question

If you wanted to round $3.99 located in Cell B3 to the nearest dollar, what is the correct Microsoft excel formula?

Answer 1

The formula is B.=ROUND(B3,0)

So, the format is = ROUND (cell #, # of decimal places) 

well if # of decimal places is 0, it just rounds to the nearest integer.

Happy studying ^-^

Answer 2

Answer:

=ROUND(B3,0) and we got $4.00

=ROUNDUP(B3, 0) and w got $4.00

Explanation:

First we need to put on cell B3 $ 3.99

For this case we can use two functions ROUND or ROUNDUP

The general formal for ROUND is given by:

=ROUND(Numbers, # of digits)

For our case since we want to round to the nearest dollar or integer the # of digits would be 0:

=ROUND(B3,0) and we got $4.00

With the ROUNDUP formula we can do a similar procedure the general format is given by:

=ROUNDUP(Number, $ of digits to take in order to round up)

Since we want to round to the nearest dollar or integer the # of digits to round up would be 0

=ROUNDUP(B3, 0) and w got $4.00