Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
performing different calculatons on whether yes or no is selected
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
performing different calculatons on whether yes or no is selected
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) -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Gavcoop123" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
a more efficient way of performing this calculation? | Excel Discussion (Misc queries) | |||
TimeSheet calculatons Overnights | Excel Worksheet Functions | |||
performing conditional averages. | Excel Worksheet Functions | |||
Performing a convolution in a worksheet | Excel Worksheet Functions | |||
performing least squares | Excel Discussion (Misc queries) |