Can't get this OR function to work right...

[Michelle]

I have a check in a box that I want to either appear or disappear depending on the width or depth of my shape.  If either width or depth (or both) is more than 18'-10", I want the check to appear.  So I put this in the GeometryNoShow of the check mark:

=OR(NOT((Pages[Page-1]!Excel.8!Prop.InsideWidth>18 ft 10 in)),((Pages[Page-1]!Excel.8!Prop.InsideDepth>18 ft 10 in)))

It seems to work for the width, but not the depth... what have I done wrong here? 

TIA!
Michelle

[wapperdude]

Your logic construct is incorrect.  The NOT should wrap around the OR function, or you need two NOTs.  They are not equivalent:

a.)  NOT(OR(caseA, caseB)) which is equivalent to AND(NOT(CaseA), NOT(CaseB))
b.)  OR(NOT(caseA),NOT(caseB))

These give you two different results.

[Michelle]

Thanks so much!  That did the trick.  Sometimes the simplest things can hold you up forever! 

Michelle