C
CHe
I have two sheets in Excel that are matrices of certain conditions and
each condition has a logical value of true or not. I need to be able
to select a cell from each of the various columns, and then see the
outcome of possibilities as per the second matrix.
What I am looking for is the mechanism by which to enter the logical
values and to see the Boolean AND, OR etc. to work out the output in
the second matrix based on the cells selected in the first one. It's
difficult to describe but don't know where in Excel I'd go about
putting these logical combinations together to get the outputs. Does
anyone else know?
each condition has a logical value of true or not. I need to be able
to select a cell from each of the various columns, and then see the
outcome of possibilities as per the second matrix.
What I am looking for is the mechanism by which to enter the logical
values and to see the Boolean AND, OR etc. to work out the output in
the second matrix based on the cells selected in the first one. It's
difficult to describe but don't know where in Excel I'd go about
putting these logical combinations together to get the outputs. Does
anyone else know?