choose a the lowest value greater than X

[LiborioErmelindo]

i have a column of data, and from that list i want to choose the lowest value grater than a reference value.

for example
the list: 1 2 3 4 5 6
the reference: 2

what function should i use to get the lowest value grater than 2?

 

[jacqueslegrand]

Is your list always ordered?

 

[Rick Rothstein]

Give this array-entered** formula a try...

=MIN(IF(A1:A6>2,A1:A5))

**Commit this formula using CTRL+SHIFT+ENTER and not just Enter by itself

 

[taurean]

If your list is in A1:F1 and reference value is in A2 then CTRL+ SHIFT + ENTER following formula:
=MIN(IF(A1:F1>A2,A1:F1))

 

[LiborioErmelindo]

thank you guys, just solved that problem with the brackets {}