if+small functions question

Hi all!!

I have an array of numbers and i need to find the smallest value that is greater than some number on the sheet.
I'd use index+match with -1 at the end of match but my array isn't arranged by particular order.
I tried {=if(range>number,small(range,1))} but it gives the smallest value in the range. if+min do the same.

So i'm puzzled now what's wrong with if+small or what is the other way to do this.

Any help will be very appreciated. And sorry i cannot upload the file Thanks in advance

NBVC!! THank you very much. It works as it should. Sitting all day on one file resulting in total IQ disorder. Thank you that you are here when someone like me needs it.