0
In excel there is the PROCV function, where I can get close values by comparing columns.
Ex.:
 A            B
Nome         Dinheiro
Maria        200
João         1000
D                  E          F
Categoria          Min        Max
Médio              0          200
Alto               201        1000
If I use call PROCV(B2,E:F,1,0), it would return me the nearest value between Min,Max in case the result would be "High".
There is something similar in Sql, other than BETWEEN?
Hello, Emerson. No welcome. Further develop your answer. Explain, for example, how your solution works. In this way, your answer will be more useful to the author(a) and to those who find it more.
– Pablo Almeida