IF statement syntax help

[ddub25]

Can anyone help with the construction of this IF Statement?

IF B960="", return ""
IF B960<>"" AND E960="post", return 0
IF B960<>"" AND E960="pre" , return "?"
IF B960<>"" AND E960="n/a" , return "n/a"

Thanks.

Dan

 

[njimack]

=IF(B960="","",IF(E960="post",0,IF(E960="pre","?",IF(E960="n/a","n/a"))))

 

[ddub25]

Thanks very much.

Dan