Apr 07 2019 02:51 PM
I am trying to find a way to sum dollar/cents amounts that were calculated as percentages of other amounts AND not end up with rounding errors (without having to manually type amount rounded to 2 places in a different cell).
Specifically, for example: I want to add 4% of a $26050.46 PLUS .25% of the same number. They have to be calculated and rounded separately and then I need the total of those two dollar amounts.
$1042.02 + $65.13 = $1107.15
NOT
$ 1042.0184 + $ 65.12615 = $ 1107.14
Is that possible?
Apr 07 2019 07:14 PM
Feb 19 2022 07:09 AM