vba - Rounding a number to the nearest 5 or 10 or X

Question

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

Given numbers like 499, 73433, 2348 what VBA can I use to round to the nearest 5 or 10? or an arbitrary number?

By 5:

 499 ->  500
2348 -> 2350
7343 -> 7345

By 10:

 499 ->  500
2348 -> 2350
7343 -> 7340

etc.

See Question&Answers more detail:os

与恶龙缠斗过久,自身亦成为恶龙；凝视深渊过久,深渊将回以凝视…

1.3k views

1 Answer

深蓝 · Answer 1 · 2021-10-16T23:30:27+0000

answered Oct 17, 2021 by 深蓝 (71.8m points)

It's simple math. Given a number X and a rounding factor N, the formula would be:

round(X / N)*N

与恶龙缠斗过久,自身亦成为恶龙；凝视深渊过久,深渊将回以凝视…