Which formula would you use to round the number in cell B5 to the nearest 10?

Answer 1

The formula that can be used to round the number in cell B5 to the nearest 10 is:

=ROUND(B5/10,0)*10