I am for some reason having problems with this formula. I am using it in conjunction with conditional formating that says if the difference between the some of BC and BD 213 is Greater/Less Than/=To the some of BH:CY213 then the cell will return that difference with a color( yellow=greater, Green= 0.00, Red= Less). The problem that I find randomly is that sometimes the difference shows 0.00 but shows red or yellow. Extending the resulting number out to 30 places shows that these numbers somehow show a number +/- out in the 23rd place. All of the numbers summed in the formula are formated currency in GBP to 2 places. The summed numbers do not show anything but 0 beyond the two digits I formated the cell for. I am not great at creating formula so have attempted to insert rounding and truncating functions without success (receive formula errors). Can someone show or explain to me how to kill any digits beyond 2.
Thanks In Advance
Scott
Bookmarks