Forum Discussion

CParker's avatar
CParker
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's avatar
    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”)
CParker's avatar
CParker
Copper Contributor
Mar 04, 2019

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

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

Resources