If Statements Directed to Single Cell?

[dhanna011]

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,

[FDibbins]

Hi

Is "open Cut" 1 method number or 2?
Will you only ever have 2 "methods"
What do you want to happen if there are 2 "methods"?

[dhanna011]

Open Cut is "one method". If there are two methods, I want it to perform both condition calculations just so I can then create a new function later on that will sum all of the sub-totals.

Also it may indeed go above two methods.

[FDibbins]

OK, so if you have something like "Open Cut" and something else like "FCIPP SCIPP"...plus other unknown combinations, how will excel determine that a particular pair (or maybe 3 or 4 sets) needs to be split apart or not?

I would suggest that you give some thought to better organising your data so that each "method" is seperated

[dhanna011]

Thank you,

I will give it another go and see how it turns out. The problem is, that I essentially cannot seperate the methods by a organized group because they are really ordered by date and manhole #.

I may make a sample excel sheet that asks the same type of question but in terms that others may understand such as X's and Y's.