Forum Discussion
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 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.
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?
2 Replies
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?
Yes, it worked like a charm.
Thank you so much for your help, I very much appreciate.
Dennis
