In cell E1 enter =D1-C1
then copy (fill) the formula down the E column.

"Taperchart" wrote:

can someone please tell me the foumula for Amount owing subtract payment when
amount paid is column C and amount owing is column D and total owing is
column E