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,

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>

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!