If Statements Directed to Single Cell?

So in column A, I have multiple "methods/jobs" going down in a list cell by cell. I have already created the conditional IF statements.

For example, I have created if A1 = 'calculations sheet'A1 (A1 is method number 1 text is on a data sheet on the other tab) then it will do some calculations for me. So I have done those for all of my different methods.

My only problem is, I may encounter the issue where there maybe multiple methods/jobs on a single cell.

So I am essentially trying to figure out how to tell excel to perform the calculations (these are in a row), via the method(s) shown in the first cell.

I have attached the sheet that I am working with, you can see the first box (in purple) is A1. I have two text values, but my formulas only work if one value is there.

Thank you,