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