'If statement between columns Google Sheets

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.

arraysif-statementgoogle-sheetssumconditional-formatting


Solution 1:[1]

try in D2:

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

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 player0

Related Questions