Formulae to stop incomplete rows showing a value

[LesHunter]

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,

[TABLE="width: 1016"]
<tbody>[TR]
[TD]George avery[/TD]
[TD]£102.00[/TD]
[TD]22 November 2017[/TD]
[TD]£102.00[/TD]
[TD]Due In-27 Days[/TD]
[TD][/TD]
[TD]Paid[/TD]
[/TR]
[TR]
[TD]George avery[/TD]
[TD]£103.00[/TD]
[TD]23 November 2017[/TD]
[TD]£103.00[/TD]
[TD]Due In-28 Days[/TD]
[TD][/TD]
[TD]Paid[/TD]
[/TR]
[TR]
[TD]George avery[/TD]
[TD]£104.00[/TD]
[TD]24 November 2017[/TD]
[TD][/TD]
[TD]Due In-29 Days[/TD]
[TD][/TD]
[TD]Outstanding [/TD]
[/TR]
[TR]
[TD]George avery[/TD]
[TD]£105.00[/TD]
[TD]25 November 2017[/TD]
[TD][/TD]
[TD]Due In-30 Days[/TD]
[TD][/TD]
[TD]Outstanding [/TD]
[/TR]
[TR]
[TD]George avery[/TD]
[TD]£106.00[/TD]
[TD]26 November 2017[/TD]
[TD]£106.00[/TD]
[TD]Due In-31 Days[/TD]
[TD][/TD]
[TD]Paid[/TD]
[/TR]
[TR]
[TD]George avery[/TD]
[TD]£107.00[/TD]
[TD]27 November 2017[/TD]
[TD]£107.00[/TD]
[TD]Due In-32 Days[/TD]
[TD][/TD]
[TD]Paid[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Outstanding [/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Outstanding [/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Outstanding [/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Outstanding [/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Outstanding [/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Outstanding [/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Outstanding [/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Outstanding [/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Outstanding [/TD]
[/TR]
</tbody>[/TABLE]
Hope this example helps
thanks in anticipation
Les Hunter</d55,"under>

 

[Joe4]

One way is to nest another IF around the whole statement, checking for some required column being blank, and if it is, return a blank, otherwise, go through the formula you have, i.e.

[COLOR=#333333]=IF(A55="","",IF(F55="","[/COLOR][COLOR=#ff0000][B]Outstanding[/B][/COLOR][COLOR=#333333] ",IFS(F55=D55,"Paid",F55[/COLOR]<d55,"under paid",f55="" style="color: rgb(51, 51, 51); background-color: rgb(250, 250, 250);">D55,"Credit")))</d55,"under>

 

[LesHunter]

Hi Joe4,
what can I say, worked beautifully, that finished the last piece in the puzzle. Thank you so much

Thank you for your time, and your knowledge
a new piece of knowledge every day creates a better person.
glad to meet your acquaintance.

 

[Joe4]

You are welcome.
Glad I was able to help!