using % in conditional formatting

The question is: The person passes the test if the total is at least 50% OR the person participates in funding( noted as “yes”)

When I type the formula =if(or($D2>=50%; $E2= “yes”; “pass”; “no pass”) Excel gives me an error and doesnt calculate when I type the 50%. 

How can this be solved 

By: katre

Leave a Reply

Your email address will not be published. Required fields are marked *