On Nov 27, 6:59*pm, Shayla2008
wrote:
the TRUNC function has fixed my problem.

The TRUNC function does not give you the same result as (you wrote)
"formatting in the cells are for 2 decimal places". Excel rounds, not
truncates.

Use the ROUND function if you want to (you wrote) "ensure the formula
is also calculating to only the 2nd decimal place".