Round up Formula required

[kngowtham]

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

[Aaron_Harter · Accepted solution]

Hi @kngowtham, 

Check out the CEIL function:

 

[JosephSerpis · Accepted solution]

I mocked up a workflow let me know what you think?

[CherylH]

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

[mst3k]

floor() will always round down to the nearest integer:

651.25 becomes 651

651.75 also becomes 651

[CherylH]

What is formula to round to nearest integer?

651.25=651   and 651.75=652?

I know it's a entry level question....

[atcodedog05]

_

[Christina_H]

@CherylH You can use Round(x,mult) to round to the nearest integer e.g. Round([Number], 1)

[CherylH]

Thank you!