If a cell is less than the number in that different cell, or if all items in the range are smaller?

would something like the below work? Start your list at A2; $D$1 is your cell with the value you are testing for.

=if(A2<$D$1,0,if(A2>$D$1,A2,if(A2=$D$1,{true condition},"ERROR")))

or

=if(A2<=$D$1,0,if(A2>$D$1,A2,"error"))

## Like this thread? Share it with others