If Statement

[danieldors]

Hello,

I have two columns drivercompletedby and asvrcompletedby. Im trying to use both columns to return ran&unrun based on the following:

drivercompletedby ='MES$' or '' and asvrcompleted by='' returns unrun, rest would be ran. Any help is appreciated.

[Digvijay_Singh]

Pl share some sample data and expected output, I am sure someone would be help you out to format your IF statement.

[Iswarya_ · Accepted solution]

Hi @danieldors ,

=IF(WildMatch(drivercompletedby,'MES$','') and WildMatch(asvrcompletedby,''),'Unrun','Ran')