I am trying to stop the non completed rows from filling the response "outstanding" in the empty rows below
=IF(F55="","Outstanding ",IFS(F55=D55,"Paid",F55<d55,"under paid",f55="">D55,"Credit"))
If I replace the word outstanding with just "", then it doesn't put anything in the empty rows...