Formula or function to use - Microsoft Community

	paid	outstanding
	$100	$200
	$200	$100
	$0	$300
total

how create formula  when pays more can update amount paid automatically updates outstanding amount? , totals down bottom? total cost $300 per unit.

hello,

if convert data excel table object (with insert > table), can have totals row , calculation automatically applied new rows of data , included in total. consider screenshot:

the total row has been added ticking box in table design ribbon. formula in column d is 

=[amount owed]-[paid]

you can insert new row usual commands, or select last cell above total in column d , use tab insert new row.

Office / Excel / Windows 10 / Office 365 Home