I need a round up formula to the whole number (not rounding to the nearest integer)
For Ex:
650.75 should become 651
650.25 also needed to be 651
650.00 should remain 650
Solved! Go to Solution.
How do you round up or down? This formula only rounds up: ceil([Case Sales Vol CNV])
For example: 651.25=651 651.75=652
floor() will always round down to the nearest integer:
651.25 becomes 651
651.75 also becomes 651
What is formula to round to nearest integer?
651.25=651 and 651.75=652?
I know it's a entry level question....
_
@CherylH You can use Round(x,mult) to round to the nearest integer e.g. Round([Number], 1)
Thank you!