performing different calculatons on whether yes or no is selected

  • Thread starter Thread starter Gavcoop123
  • Start date Start date
G

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
 
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)
 
Back
Top