Forum Discussion

Witucker's avatar
Witucker
Copper Contributor
May 08, 2023

Formula

How do I formulate in excel the value of an amount overpaid or underpaid. For example: target amount is $1600, a payment is made for $1550, I want to show that it’s -$50 on the ledger or any other amount that may be lacking from target. AND if a payment is made for more than the target, I want to show the difference paid in that as well

Resources