IF function

[dennis houle]

I am having trouble with the IF function.  I want to search text in a cell and if it contains an asterisk, then I'd like the cell next to it to display the word Late. 

So, if  cell C3 shows Jim* or Jim*Carter I want cell C4 to display Late.  But if cell C3 is only Jim, then I want cell C4 to be left blank.

[#2 · Accepted solution]

Hello,

you can use the Find() function for that. Find() will return the position of the found text as a number. If the text is not found, then Find() will return an error. Wrap find into an IsNumber() function and put that into the condition of an IF() statement like this:

=IF(ISNUMBER(FIND("*",C3)),"Late","")

Does that work for you?

[#3]

Yes, it worked like a charm.

Thank you so much for your help, I very much appreciate.

Dennis