Should be a simple if formula but is not working.

[DeanRobinson]

=IF(OR(C8=314,371,415,512,516,518),"S",IF(C8=544,"N",IF(C8=511,"N",IF(C8=577,"NW",""))))

Not to sure what ive done wrong here, but if cell c8= 511 it should return N but it doesnt it returns S, anyone got any ideas???

 

[VoG]

Try

=IF(OR(C8=314,C8=371,C8=415,C8=512,C8=516,C8=518),"S",IF(C8=544,"N",IF(C8=511,"N",IF(C8=577,"NW",""))))