Main menu
You are here
ROUNDing to nearest No.
Sun, 26/03/2006 - 22:36 — LS
Hello,
i noticed you have floor and ceiling functions which round a
number either up or down,
but i need to round to the nearest whole number,
i tried ROUND(X,number of decimals) like excel but that doesnt work
do you have a function that does that?
cheers
LS
Forums:
ROUNDing to nearest No.
No, though we should add it as it is a common requirement. In the mean time you can use the popular workaround, floor(x+0.5), to achieve the same result.
--Jasper
ROUNDing to nearest No.
Or the less popular (floor(((10^n)*x)+0.5))/(10^n) to round to n decimal places. It's probably possible to include this as a function in your personal profile, so that it can be used as round(x,n) in the model, but I've forgotten how to do that.
Alastair