Forum Discussion

rrjwt's avatar
rrjwt
Copper Contributor
Jan 31, 2023

Help in create a conditional formula

I need help guys to create a formula based upon the column "Name" and "Answer". 

 

  1. If name=Identify or protect and Answer=yes then add 3.5 in total
  2. If name=Identify or protect and Answer=Partial then add 1.5 in total
  3. If name=Recover and Answer=yes then add 5 in total

 

I want one formula for this conditions. Your help is really appreciate. 

 

S.noNameDataData1data2Answer
1IdentifyABCDnothingnothingYes
2IdentifyXYZnothingnothingPartial
3ProtectXYZnothingnothingYes
4RecoverXYZnothingnothingYes
total    0
excel
Formulas and Functions
Macros and VBA

1 Reply

Sort By
  • Jihad Al-Jarady's avatar
    Jihad Al-Jarady
    Steel Contributor
    Jan 31, 2023

    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)

     

Resources