The challenge is that the AND function and the OR function bothaggregatevalues to a single result.
One workaround to this limitation is to use the MAP function, as explained below.
All data is in anExcel Tablenameddatain the range B5:C15.
For each row in the table, we want a TRUE or FALSE result.
MAP function
One solution to implementing the logic above is to use theMAP function.
The MAP function “maps” a customLAMBDA functionto each value in a suppliedarray.
These names are arbitrary and you’ve got the option to use any valid name you like .
AND returns TRUEonly if all the conditions are met.
If any conditions are not met, the AND function returns FALSE.
OR returns TRUEif any condition is TRUE.
If all conditions are FALSE, the OR function returns FALSE.
The OR function is often used with the IF function and can be combined…
