IFS displaying spill range and not just one result?

[J-Des000]

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 all 10 cells and not just have the first true result outputted?

For example output should be TRUE, FALSE, FALSE, ETC with TRUE and FALSE being their respective values.

Right now output is only TRUE.

Thanks!

[#2 · Accepted solution]

=IF(($A$1:$A$10=5)*($B$1:$B$10=10)=1,TRUE,FALSE)