excel - Using AND and OR together on the IF function -

hi have been trying fin out how use , and or on same formula.

i'm trying resolve following issue :

the person discount if working on cerrovial project or if working on parinas project risk of job must low

i tried use formula , excel gave me error , fixed formula not know if correct or "*" means

=if(or(d14="cerrovial",d14="parinas")*and(e14="low"),"8%","")

this table

you close:

=if(and(or(d14="cerrovial",d14="parinas"),e14="low"),"8%","")

all elements of and need in and(...), or, had done correctly.

Abdulaziz