If statement with two variables

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

Check that you don't have a trailing space in E4.

Hope this helps.

Pete

My guess would be the yes in E4 is not the exact yes in your formula. Any chance there is an extra space or anything in E4?

I can only imagine all the yesses might have a space after the "s"? Try =IF(OR(LEFT(E4,3)="yes",E4="N/A"),G4,0)
Or you can just figure out if there is a space after the s, and if there is then filter column E for only yes's, then change the top one to say only "yes" (no spaces) and copy the whole way down