Skip to Content
avatar image
Former Member

I need to round this formula to 2 decimals. Does anyone know how I can do that?

=If(IsError(ToNumber(Replace([Total Budget];",";""))-[Expenditures]);"";ToNumber(Replace([Total Budget];",";""))-[Expenditures]-[Encumbrances]-[Pre Encumbrances])

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • May 18 at 07:12 PM

    multiple ways to do achieve this.

    Option1-values would be string data type

    If(IsError(ToNumber(Replace([Total Budget];",";""))-[Expenditures]);"";formatnumber(ToNumber(Replace([Total Budget];",";""))-[Expenditures]-[Encumbrances]-[Pre Encumbrances]);”0.00”)

    Option 2-replaced “” to 0 in the formula.after that right click on column-formatnumber-number-custom and add values 0.00 and click ok

    If(IsError(ToNumber(Replace([Total Budget];",";""))-[Expenditures]);0;ToNumber(Replace([Total Budget];",";""))-[Expenditures]-[Encumbrances]-[Pre Encumbrances])

    Add comment
    10|10000 characters needed characters exceeded