Using IF, AND & OR, I have managed to obtain TRUE & FALSE returns for 3 Cells where each has 2 possible values. There are 8 possible different Combinations and if any of these are TRUE the value of cell AF21 is returned but if FALSE then "0" is returned.
EXAMPLE
=IF(OR(AND($B$5="EW",D19="W",E19="W",F19="P"),AND($B$5="EW",D19="W",E19="W",F19="W"),AND($B$5="EW",D19="W",E19="P",F19="W"),AND($B$5="EW",D19="W",E19="P",F19="P"),AND($B$5="EW",D19="P",E19="P",F19="P"),AND($B$5="EW",D19="P",E19="P",F19="W"),AND($B$5="EW",D19="P",E19="W",F19="P"),AND($B$5="EW",D19="P",E19="W",F19="W")),AF21,0)
The cells are D19,E19 & F19 and Possible Values are "W" & "P"
I am looking to expand this for 5 Cells each with 2 possible values which will return 32 possible combinations.
Is there a valid syntax that will shorten the formula, perhaps by identifying each cell and each possible value. Each possible combination will return TRUE.
I welcome any possible resolutions
EXAMPLE
=IF(OR(AND($B$5="EW",D19="W",E19="W",F19="P"),AND($B$5="EW",D19="W",E19="W",F19="W"),AND($B$5="EW",D19="W",E19="P",F19="W"),AND($B$5="EW",D19="W",E19="P",F19="P"),AND($B$5="EW",D19="P",E19="P",F19="P"),AND($B$5="EW",D19="P",E19="P",F19="W"),AND($B$5="EW",D19="P",E19="W",F19="P"),AND($B$5="EW",D19="P",E19="W",F19="W")),AF21,0)
The cells are D19,E19 & F19 and Possible Values are "W" & "P"
I am looking to expand this for 5 Cells each with 2 possible values which will return 32 possible combinations.
Is there a valid syntax that will shorten the formula, perhaps by identifying each cell and each possible value. Each possible combination will return TRUE.
I welcome any possible resolutions