When the combination includes 1 value from Y and 1 value from Z then IF, AND and OR functionality is workable, if not intricate.

I am hoping that there might be another option available in Excel that will provide a solution for multiple possible combinations from multiple sources. TRUE / FALSE is acceptable as Source Z may have a different value which should provide a FALSE return (ZERO)

I would also be interested if the use of a macro with VBA code might be a possibility.

AIM = Cell C to be populated with the value of Cell A OR the value of Cell B OR the value of Cell A + Cell B depending on the combination determined by the combinations of Sources Y & Z (See combinations Below)

Source X = two cells (Cell A & Cell B) each with values populated from a database.

Source Y (Cell 1) has two possible values (eg F & G) one one of which can be applied to each calculation. Thisi is readily determined using IF & AND functionality as only one value can be applied to the calculation.

Source Z however uses combinations of up to 3 additional cells (eg. A5. A6 & A7). Each cell has 2 possible valid values (eg W & E) giving 8 possible unique combinations (eg WWW, WWE, WEE etc.). The formula needs to include all possible combinations of Source Z for each Value of Source Z. So there are possibly 16 different combinations

Cell C = Value Cell A if Options are (Source Y Value = F Acceptable Source Z Cell A5, A6 & A7 combinations WWW, WWE, WEW & EWW {eg. A5 ="W",A6="W",A7="W" etc.})

Cell C = Value Cell B if Options are (Source Y Value = G Acceptable Source Z Cell A5, A6 & A7 combinations WEE, EEE, EEW & EWE)

Cell C = Value Cells A+B if Options are (Source Y Value = G Acceptable Source Z Cell A5, A6 & A7 combinations WWW, WWE, WEW, WEE, EWW, EEE, EEW & EWE).

Any help would be greatfuly accepted