I'm trying to run a Small If formula with the criteria of numbers in a certain column being below a particular number. The formula will not work with <= but it will work with a >=.


The formula I'm running is {=SMALL(IF($E$6:$E$132<=$C$1,$Q$6:$Q$132),1)} and for some reason it works if the criteria is >= but will not work with the criteria <=. I'm kind of at a loss...