I have a calculation that can give me a result with 3 places to the right of the decimal point. "If ( Contract To = "Build All Stages" ; Contract Total / 100 * C_B Perc Change - Contract Deposit)". How do I restrict the answer to 2 decimal places. At the moment when I convert this to text the last number can be different by one, for example the calculation may be $148.436 which is $148.44 when taken back to two decimal places, but the figure converted to text will show One Hundred and Forty Eight Dollars and Forty Three Cents. I need this to be One Hundred and Forty Eight Dollars and Forty Four Cents.

Use the Round ( ) function on the original calculation.

Round ( Contract Total / 100 * C_B Perc Change - Contract Deposit ; 2 )

Then do your text formatting.