Forum Discussion

Copper Contributor

Mar 04, 2019

Solved

IF/THEN help

Hi - I think I need an if/then formula, but I am not 100% positive. I am creating a spreadsheet to track trainer certifications and availability. I need to determine if the course (column B) is o...

Formulas and Functions

Twifoo
Mar 04, 2019
Assuming the certifications are not more than 9, you can use this formula starting in F2:
=IF(ISNUMBER(FIND(B2,E2)),
“Yes”,
“No”)

Twifoo

Silver Contributor

Mar 04, 2019

Assuming the certifications are not more than 9, you can use this formula starting in F2:
=IF(ISNUMBER(FIND(B2,E2)),
“Yes”,
“No”)

CParker

Copper Contributor

Mar 04, 2019

Thank you very much! That did exactly what I needed it to do. :)

Twifoo
Silver Contributor
Mar 04, 2019
You’re very much welcome!