- First, determine the multiple of 10 or 5 that you want to round to. In your case, you want to round to the nearest multiple of 10.
- Divide the number you want to round by the multiple you determined in step 1. In your example, you would divide 400 by 10, which gives you 40.
- Use the ROUND function to round the result of step 2 to the nearest whole number. In your example, you would use the formula =ROUND(40,0), which gives you 40.
- Multiply the result of step 3 by the multiple you determined in step 1. In your example, you would multiply 40 by 10, which gives you 400.
To apply this to your specific scenario, you can use the following formula to round the number of doses purchased with fund #2 to the nearest multiple of 10:
=ROUND(133/10,0)*10
This formula divides
133 by
10 to get
13.3, rounds it to the nearest whole number (which is
13), and then multiplies it by
10 to get
130.
You can use a similar formula to round the number of doses purchased with fund #3 to the nearest multiple of 10:
=ROUND(267/10,0)*10
This formula divides
267 by
10 to get
26.7, rounds it to the nearest whole number (which is
27), and then multiplies it by
10 to get
270.
When you add these two rounded numbers together (
130 + 270), you get
400, which is the total number of doses you started with.