Small array that shows smallest only if it is between numbers X and X?

[Johnathan]

=SMALL((F42:AS42,F112:AS112),1) )

Is there a way to modify this above code to only show a value that is greater than -50 and under +50

its pulling overages and shortages in cash from my job..
If so how exactly would i do this? Thank you SOOO MUCH!

completely stuck

[day92]

Duplicate post

http://www.excelforum.com/excel-gene...of-values.html