Our management accounts packs are linked to a number of detailed disclosures, similar to annual financials. Does anyone have a way of automating the "true" rounding difference (i.e. difference of 1 that aren't arising due to use of pence). We have used =ROUND to get items down to 0 DP, but always spend time chasing £1-£2 round notes to ensure they agree throughout our packs.
Any help appreciated,