Wildcards in iif/then statements

[ballerado]

I need an equation that says "IF column M contains data, display the data in column Q, if it does not contain data, return "Unknown"" I have been trying for several hours but cant get the wildcard combination right. Can anyone help with this?

[jeffreybrown]

Not so sure what you mean by "wildcard combination", but try...

=IF(M2<>"",Q2,"Unknown")

...if this does not do it, please show what you have tried.

[ballerado]

Thats the one! I didnt know you would need the <> symbols thanks a ton. rep given!

[jeffreybrown]

You're welcome…glad you have a workable solution and thanks for the feedback...

(The 'rep' also )

[jeffreybrown]

You're welcome…glad you have a workable solution and thanks for the feedback...

(The 'rep' also )