Forum Discussion
J-Des000
Aug 02, 2024Brass Contributor
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 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!
=IF(($A$1:$A$10=5)*($B$1:$B$10=10)=1,TRUE,FALSE)
1 Reply
Sort By
- Rodrigo_Steel Contributor
=IF(($A$1:$A$10=5)*($B$1:$B$10=10)=1,TRUE,FALSE)