Hi,I want to calculate how much a person a owes to someone who has paid to him. As attached in the excel sheet, Alex paid $3780 to Frank & $1370 to Roseline. So, $3780 should appear in range D14 & (-$1630) in range E15 ($3000 in E7 less: $1370 in E5) and so on.

HiCheck attached file. Used a Table but that's not mandatory

i found the result different.calc.xlsm

Connect with experts and redefine what’s possible at work – join us at the Microsoft 365 Community Conference May 6-8. Learn more >

Forum Discussion

Dharmendra_Bharwad

Brass Contributor

Dec 23, 2024

Fund Calculator

Hi,

I want to calculate how much a person a owes to someone who has paid to him. As attached in the excel sheet, Alex paid $3780 to Frank & $1370 to Roseline. So, $3780 should appear in range D14 & (-$1630) in range E15 ($3000 in E7 less: $1370 in E5) and so on.

Formulas and Functions

Lorenzo
Silver Contributor
Dec 23, 2024
Hi
Check attached file. Used a Table but that's not mandatory
Calc.xlsx11 KB
arnel_gp
Steel Contributor
Dec 23, 2024
i found the result different.
calc.xlsm

Forum Discussion

Fund Calculator

Share

Resources