performing different calculatons on whether yes or no is selected

[Gavcoop123]

Hi

I am trying to build a model where one calculation is performed if the cell
contains a "yes" but if it contains a "no" it does not perform the calculation

and i cant work out how to do it.

essentially i need to build a formula that has does this three times over.
What i am trying to achieve is for the user of the model to select three "yes
/ no" options from a list in the respective cells, then perform a calculation
on the "yes's" but not do the calculation on the "no's".

So.... if all "yes'" are selected three calcualtions are done and added to
the original figure and if 2 are selected then those 2 calculations are
performed and added to the original and of couse if just one then just one.

Hope this makes sense.

any help would be greatly appreciated
Gavin

 

[Max]

One example which could be relevant here
Assuming DVs in A2:C2 down, where corresponding values in E2:G2 are to be
multiplied by 2 for any "yes" DV selections, then the total is calculated,
you could use this expression in H2, copied down:
=SUMPRODUCT(--(A2:C2="yes"),E2:G2*2)