If CountIf - Help Displaying Blank Cell

[Barteh]

Hi Guys,
I could really do with some help if possible, I have a cell that looks up a column any will display "Complete" when all other cells in column K are "Complete" or "Outstanding" when any other cells in column K contain Outstanding.
What I'd like to do is for this cell not to display ANY text if column K is is empty and doesnt contain any text.

The formula I have is;

=IF(COUNTIF('Document Request'!K10:K40,"Outstanding")<=0, "Complete", " Outstanding")

Can anyone offer any suggestions?
Thanks in advance.

 

[Joe4]

Is this what you are looking for?

=IF(COUNTBLANK([COLOR=#333333]'Document Request'![/COLOR]K10:K40)=31,"",IF(COUNTIF([COLOR=#333333]'Document Request'![/COLOR]K10:K40,"Outstanding")>0,"Outstanding",IF(COUNTIF([COLOR=#333333]'Document Request'![/COLOR]K10:K40,"Complete")=31,"Complete","No conditions met")))

Basically, what this does is the following:
1. If all cells in K10:K40 are blank, it returns nothing
2. If any cells in K10:K40 say "Oustanding", it returns "Outstanding"
3. If all cells in K10:K40 are "Complete", it returns "Complete"
4. Otherwise, it returns "No conditions met".

You did not specify what happens if the cells are a mixture of blanks and "Complete", so condition 4 would be met.

 

[Barteh]

Close enough for me, thank for you very much for your time on a Friday evening. Very kind of you.

 

[Joe4]

You are welcome. Glad it works for you!