multiple 'ifs'

[GlennC]

How would I go about a calculation involving more than one test for an 'if' calculation. In other words, I need a calculation that in effect says: If(a=(b or c or d), e). The 'Case' function allows multiple scenarios, but the 'if' calc doesn't seem to. I don't see "else" or "elseif" type functions available except in scripts.

With the 'Case' function, how do I create a Case statement where the test involves comparing two sets of information? eg: something like Case((field a = field b AND field c = field d), result).

Your help and a lessening of my confused state is very much appreciated.

Glenn

[andygaunt]

If (a=b or a=c or a=d,e,"")

HTH