Skip to Content

Round Up 4.1 to 5

I need to round up all my sales:

example

4.2 need to see 5

1.1 need to see 2

3.8 need to see 4

2.3 need to see 3

I tried with the Round (variable, 0) but eh formula don't do it.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Feb 15 at 12:28 PM

    use this formula.

    =Round(If(ToNumber(Right(FormatNumber([Number];"#.#");1))>5) Then [Number] Else [Number]+1;0)

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 23 at 10:41 AM

    use this formula.i have changed the condition where +1 will be added if decimal part is above 4. earleir it was 5.

    =Round(If(Tonumber(Right(FormatNumber([Number];"0.0");1))>4) or (toNumber(Right(FormatNumber([Number];"0.0");1))=0)) Then [Number] Else [Number]+1;0)

    Add comment
    10|10000 characters needed characters exceeded