I have a question and I do not know if there is any function like this. I have this table
96.549
160.914
402.284
643.654
1.045.938
1.609.135
I have a place where a result will appear for example:
1.200.000,00
And I want that table to tell me the larger amount to follow at 1,200,000.00 With the larger function does not work.
If I understand correctly you have a list of values
1
2
3
4
5
6
And a key value X. You want to return the smallest value that is greater than X. Correct? If X is 4, you want the 5.
Use the following:
=MÍNIMO(SE(A1:A10>B1;A1:A10))
Calculate the minimum element of the list formed by elements that are larger than B1.
But important: This is a matrix formula . When you are done typing, type Ctrl + Shift + Enter instead of just Enter .
Source: link