Hi I am trying to apply a math formula to column based on a Y/N in a previous column. I would like to apply this to a range of cells in the sheet. EX:

If column C = yes

column D = sum(A*B   (0.1*A*B))

else

column D = sum(A*B)

Again, i would like to apply this to a whole sheet. Also, column C is a drop down list Yes or no.

CodePudding user response：

try in D2:

=INDEX(IF(C2:C="yes"; (A2:A*B2:B) (0.1*A2:A*B2:B); A2:A*B2:B))