Blank record in calculated field

[Anonymous]

Here is my calculated field formula

IF(WildMatch([State],'* *',[Title],'*Mr*'),'Unknown',)

If the field State is blank with no data and the field Title is ‘Mr’ then I want the calculated field to display ‘Unknown’ for that record.  I don’t think I have the correct syntax for the blank field with no data, can you help?

[andrey_krylov · Accepted solution]

Hi, Boon, you have to use wildmatch() for every field. So, it would be

If(WildMatch([State], '* *') and WildMatch([Title], '*Mr*'), 'Unknown')

But as for blank values, i'd do it differently

If(len([State]) = 0 and WildMatch([Title], '*Mr*'), 'Unknown')