Hi -- I need some assistance with formatting my formula output to 2 decimals.
Existing Formula:
="Avg Mos: " &MOD(((SUM($J$17:$J$26)*12+SUM($K$17:$K$26))/COUNTIFS($J$17:$J$26,"<>*?",$J$17:$J$26,"<>")),12)
Current Output:
Avg Mos: 0.0999999999999943
Desired Output:
Avg Mos: 0.10
Bookmarks