Lets say I need a number to be rounded to the nearest multiple of 5, 10, 32... etc
Examples:
Multiples of 5:
0, 5, 10, 15, 20 ,25
12 would = 10
Multiples of 10:
0, 10, 20 , 30, 40
16 would = 20
Multiples of 32:
0, 32, 64, 96, 128
89 would = 96
What about rounding up or down and not to nearest? As in:
Rounding down to make 14 = 10 or
Rounding up to make 11 = 15?
I am aware I may have to create a variable, just not sure if there is an expression for this already or if I have to take the number and put it in a formula.
Also will Round(5.5) = 5 or 6?
I have only read 5.4 = 5 and 5.6 = 6 in forum examples.
I never read what would happen if it was in the exact middle.
Does it just pick up or down randomly?
How sensitive is Ceil and Floor?
would floor(5.99999) still be 5?
would ceil(5.00001) still be 5?