IF Formula

[Bear]

Hi guys

Would you teach me how to set the if formula under the following conditions:

If the selective range showed "AIP" OR "YES", then add 20%

For example
if there are 2nos "AIP", then the cell shall be 40%
if there are 2nos "AIP" and 1no "YES", then the cell shall be 60%

 

[AliGW]

There is no data in the ranges that you have used in your formula.

What does "2nos" mean? Add 20% or 60% to what?

Very confusing...

 

[vletm]

Bear
I try to figure Your logic ... check G-column.

 

[p45cal]

In A3:
=(COUNTIF(B3:F3,"AIP")+COUNTIF(B3:F3,"YES"))*0.2

 

[John Jairo V]

Hi, to all!

Could be too:
=0.2*SUMPRODUCT(N(B3:F3={"AIP";"YES"}))
Or:
=0.2*SUM(COUNTIF(B3:F3,{"AIP","YES"}))

If you only have three values (N/A, AIP and YES), and no have empty cells, could be too:
=0.2*COUNTIF(B3:F3,"<>N/A")

Blessings!

 

[Bear]

In A3:
=(COUNTIF(B3:F3,"AIP")+COUNTIF(B3:F3,"YES"))*0.2

Thanks p45cal, it works really well.

 

[Bear]

Hi, to all!

Could be too:
=0.2*SUMPRODUCT(N(B3:F3={"AIP";"YES"}))
Or:
=0.2*SUM(COUNTIF(B3:F3,{"AIP","YES"}))

If you only have three values (N/A, AIP and YES), and no have empty cells, could be too:
=0.2*COUNTIF(B3:F3,"<>N/A")

Blessings!

Thank you John, it works really well. Bravo!!