how to round

[alexz99]

Can you tell me how to round up rates? so as not to put 138 but round up to 150 for example

[Alex]

Can you tell me how to round up rates? so as not to put 138 but round up to 150 for example

you can easily round to closest INT number (like 2.76 to 3):

Code: Select all

(X + 0.5)^0

rounding to closest 50 number will be more tricky i think. Can you tell the application for it?

i think you can do:

Code: Select all

((X / 50 + 0.5)^0) * 50