title: Using AND and OR together on the IF function
body: <p>Hi all I have been trying to fin out how to use AND and OR together on the same formula. </p>
  
  <p>I'm trying to resolve the following issue : </p>
  
  <p>The person will get a discount only if they are working on the Cerrovial project or if they are working on the Parinas project but the risk of the job must be Low</p>
  
  <p>I tried to use a formula and excel gave me an error and also fixed my formula but I do not know if this is correct or what the "*" means</p>
  
  <p><code>=IF(OR(D14="CerroVial",D14="Parinas")*AND(E14="Low"),"8%","")</code></p>
  
  <p><img src="https://i.stack.imgur.com/4OJHr.png" alt="This is the table"></p>