Rounding numbers in Excel is a common task that is used in various business and financial calculations. However, rounding to the nearest 5 can be a bit tricky, especially when dealing with negative numbers. In this article, we will show you how to use the round function in Excel to round numbers to the nearest 5.

First, you need to download the Excel workbook for magic trick number 380. You can do this by visiting the creator’s college website and downloading the workbook. Once you have the workbook, open it in Excel and follow along with the tutorial.

To round a number to the nearest 5, we will be using the round function. This function can do the same thing as the M round function, but it requires a bit more work. We will start with negative numbers.

In the workbook, there are four negative numbers that we want to round to the nearest 5. The first number is -6, which should be rounded down to -5. The second number is -7, which should also be rounded down to -5. The third number is -12, which should be rounded up to -10. The fourth number is -9, which should be rounded down to -10.

To use the round function, select all of the cells that you want to round. Then, enter the formula “=ROUND(A1/5,0)*5” in the formula bar. Replace “A1” with the first cell in your selection. This formula will divide the number by 5, round it to the nearest integer, and then multiply it back by 5. This will round the number to the nearest 5.

After entering the formula, hit the “Enter” key to apply it to the first cell. Then, copy the formula and paste it into the rest of the cells in the selection. This will round all of the numbers to the nearest 5.

If you have positive numbers, you can use the same formula. However, you will need to change the formula to “=ROUND(A1/5,0)*5” and replace “A1” with the first cell in your selection. This will round the positive numbers to the nearest 5.

In conclusion, rounding to the nearest 5 in Excel is easy with the round function. By using this function, you can round both positive and negative numbers to the nearest 5. So, next time you need to round to the nearest 5, remember to use the round function.