$402.39
$20,119.26
($800.00)
($1,100.00)
The top number $402.39 should be 2% of the sum of the $20,119.26 and the two deductions of -$800 and -$1,100.
My current formula looks like this 0.02*(SUM(L11:L23))
It is adding the two negative numbers which results in a positive number. How do I get it to add the negative numbers and correctly get 2% of that?
Bookmarks