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

User OJT
by
6.4k points

1 Answer

3 votes

Answer:

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

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

Step-by-step 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

User SolaWing
by
6.6k points