wich fromula would you use to round the number in cell b5 to the nearest 10
=MROUND(B5,10)
6th drade
To round the number in cell B5 to the nearest 10, you can use the ROUND function. The formula would be:
=ROUND(B5/10, 0) * 10
Here's how the formula works:
1. Start by dividing the number in B5 by 10 using the division operator /.
2. The result of the division will be a decimal number. The ROUND function rounds this decimal number to the nearest whole number.
3. The second argument of the ROUND function is 0, which means rounding to the nearest whole number.
4. Finally, multiply the rounded result by 10 to get the final rounded value to the nearest 10.
Remember to change B5 in the formula to the actual cell reference that contains the number you want to round.