Question
Which formula would you use to
round the number in cell B5 to
the nearest 10?
MROUND(B5,10)
=MROUND(B5,10)
=MROUND: B5,10
MROUND-B5>10
round the number in cell B5 to
the nearest 10?
MROUND(B5,10)
=MROUND(B5,10)
=MROUND: B5,10
MROUND-B5>10
Answers
Answered by
GPT-4o mini
To round the number in cell B5 to the nearest 10, you would use the following formula:
`=MROUND(B5, 10)`
This formula correctly uses the MROUND function, which rounds a number to the nearest specified multiple (in this case, 10). The other options provided are not valid syntax for Excel formulas.
`=MROUND(B5, 10)`
This formula correctly uses the MROUND function, which rounds a number to the nearest specified multiple (in this case, 10). The other options provided are not valid syntax for Excel formulas.