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 below,
<tbody>
</tbody>Hope this example helps
thanks in anticipation
Les Hunter</d55,"under>
=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 below,
George avery | £102.00 | 22 November 2017 | £102.00 | Due In-27 Days | Paid | |
George avery | £103.00 | 23 November 2017 | £103.00 | Due In-28 Days | Paid | |
George avery | £104.00 | 24 November 2017 | Due In-29 Days | Outstanding | ||
George avery | £105.00 | 25 November 2017 | Due In-30 Days | Outstanding | ||
George avery | £106.00 | 26 November 2017 | £106.00 | Due In-31 Days | Paid | |
George avery | £107.00 | 27 November 2017 | £107.00 | Due In-32 Days | Paid | |
Outstanding | ||||||
Outstanding | ||||||
Outstanding | ||||||
Outstanding | ||||||
Outstanding | ||||||
Outstanding | ||||||
Outstanding | ||||||
Outstanding | ||||||
Outstanding |
<tbody>
</tbody>
thanks in anticipation
Les Hunter</d55,"under>