I know if I want to do a formula for rounding to the nearest 100 of 40% of a
number it's =ROUND(a1*40%,-2). This will automatically round to the nearest
100. However, I am looking to round to the next highest 100 so if the value
is 2,101 it will round up to 2,200. Any ideas?