Ask Your Question

bit or multiple cells

asked 2018-09-12 01:42:17 +0100

EricNZ gravatar image

The BITOR function only uses the value in two cells as arguments.

How does one BITOR cell values where the number of cells to be included is greater than 2?


edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2018-09-12 13:43:30 +0100

m.a.riosv gravatar image

Only two parameters are allowed by the function.

edit flag offensive delete link more


... so one needs to nest BITOR calls to combine more than 2 numbers: =BITOR(1;BITOR(2;4))

Mike Kaganski gravatar imageMike Kaganski ( 2018-09-12 14:15:43 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-09-12 01:42:17 +0100

Seen: 28 times

Last updated: Sep 12 '18