Hi

I need to do an if statement if a cell (E4) = "yes" or E4= "n/a" then G4,0

this is the precise formula I tried but its not working for any yes statements
=if(OR(E4="yes",E4="N/a"),G4,0)

Can anyone help
thanks
leanne