I need to find an expression that gives me a result depending on the value of a field filled from the user side.
example:
Number of employees = 53
Cost=??? in this example the result mus
employees table
MIN | MAX | COST |
0 | 25 | 2500 |
26 | 50 | 3000 |
51 | 200 | 5000 |
I tried to use lookup but it didn't worked
User | Count |
---|---|
18 | |
11 | |
7 | |
3 | |
2 |