Question

Suppose the following formula is inputted into Excel:
=MROUND(1/4,100)
The output in the cell will be:

Review Later
0.25
0.2500
1
0

Answer 1

Answer:

0

Explanation:

0.25 rounded to the nearest 100s will be outputted as 0

Answer 2

Answer: The following answer is based on excel programming.

The correct answer is 0.25.

MROUND(): If the remainder that is left over after dividing a number by a multiple is higher than or equal to half the value of the multiple, MROUND will round the value up, away from zero. It is essential that the Number and Multiple arguments have the same sign. If this is not the case, a #NUM error will be returned.

Explanation:

• The Mround function takes 2 arguments
• 1 is the number 1/4 = 0.25000
• It is a floating point number
• Therefore it requires to be rounded up
• The second argument of the Mround function is 2 which rounds the the number up to to 2 decimal places that is 0.25

#SPJ2