Sum If

TPALJA

I'm trying to do a sumif calculation that returns the dollar amount that was overpaid. I already did a simple formula of =[Open Balance Amount]@row - [Amount Paid ]@row. I wanted to know if its possible to show as a plus amount vs negative(-) amount

Leroy Noriega

You can flip the formula:

= [Amount Paid ]@row - [Open Balance Amount]@row

Leroy Noriega

You can flip the formula:

= [Amount Paid ]@row - [Open Balance Amount]@row