Count fields and show 1 or 0

S

slagg7575

OK guys, I have another problem I will post here and on another post if
nobody reads this.

I have the same 5 (A2:E2)fields, each with a 1 or 0. What I need this
time is that If A2 is 1, then I need A2 plus any 2 (1or true) of the
remaining four (B2:E2), to them have the new field box called total to
read 1 or true. If A2 is 0(false), then regardless of the other four,
the Total field must read 0 or false. Does this make sense? Thanks
again!
 
S

slagg7575

Hi,

Wow thanks for the speedy reply! It works like a charm...thanks again
Roger! I may have some more questions later...but thanks again...your
help is greatly appreciated!
 
Top