Adding Several Logical Conditions

[SemperFi]

Hello Team,

I need to be able to add several IF statement logical conditions:

If C4<=20% then is 20
If D4<=1.07% then is 20
If E4>=75% then is 20

I need to be able to add the "20" for each value if is true, in the sample all are true, the answer should be 60, if only two are true then the answer should be 40.

I appreciate any help you can offer.

Thank you

 

[Fazza]

Maybe

=((C4<=20%)+(D4<=1.07%)+(E4>=75%))*20