Quote Originally Posted by JohnTopley View Post
Just for completeness an "OR" condition uses "+".

Both work on the principle that TRUE=1, FALSE=0 so If A AND B are TRUE then we multiply (So YES it is multiply!) 1 * 1 = 1 . If either are FALSE then we have 1*0 or 0*1 =0.

For an "OR" condition we add so A OR B are TRUE we will add 1+0 or 0+1 =1: if neither are TRUE we get 0+0=0

All clear now!
Much better, I love excel, but learn something new all the time.