Forum Discussion
Help in create a conditional formula
I need help guys to create a formula based upon the column "Name" and "Answer". If name=Identify or protect and Answer=yes then add 3.5 in total If name=Identify or protect and Answer=Partial ...
Hi rrjwt
You should use a column for total to do the calculation for each row, so you can write this formula in G2
=IFS(AND(OR(B2="identify",B2="protect"),F2="yes"),3.5,AND(OR(B2="identify",B2="protect"),F2="partial"),1.5,AND(B2="recover",F2="yes"),5)