Forum Discussion
Solved
IFS displaying spill range and not just one result?
Hi, I am using the AND function with two criteria inside (e.g if equal to 5 and 10) for a range of cells (vertically, for example A1:A10) but only 1 result appears. How do I spill all results for...
=IF(($A$1:$A$10=5)*($B$1:$B$10=10)=1,TRUE,FALSE)
=IF(($A$1:$A$10=5)*($B$1:$B$10=10)=1,TRUE,FALSE)