I'm trying to figure out how QuickBooks and Excel handle their rounding. When I did an export from QB to Excel the code entered into Excel via the export is =Round(Sum(A1:A14),5). However I've got the same input data in another worksheet and when I enter the exact same formula into the other Excel worksheet I got a totally different answer. Is there a way I can get my Excel to round like QB does? I know it sounds strange but that's what I'm getting.

TIA