IF function

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 ...

Formulas & Functions

Need Help

IngeborgHawighorst
Oct 30, 2017
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?

IngeborgHawighorst

MVP

Oct 30, 2017

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?

dennis houle

Copper Contributor

Oct 30, 2017

Yes, it worked like a charm.

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

Dennis

Forum Discussion

IF function