none
Rounding in custom fields with formula's RRS feed

  • Question

  • Hi, 

    I've created a custom field based on numeric lookups:

    (1 / (([Importance - Customer] * [Importance - SSC] * [Complexity]) / 64))

    In this case the results displayed sometimes show 1.1112345445435. 

    Is it possible to round the results to whole numbers (or 2 decimals).

    Monday, February 18, 2019 4:05 PM

All replies

  • S.Bots --

    One thing I find interesting about formulas in Microsoft Project is that Excel functions can be used in Microsoft Project, even though they are not listed anywhere in the documentation or in the tool.  Your formula with rounding would be:

    Round((1 / (([Importance - Customer] * [Importance - SSC] * [Complexity]) / 64)),2)

    Hope this helps.


    Dale A. Howard [MVP]

    Monday, February 18, 2019 4:31 PM
    Moderator