HI , I would like to update a field with a certain value based on a range in another field.
i.e if the number entered in one field is between 180 - 200, 200 - 220 etc I would like to update another field with 0, -0.1, +0.2 etc
Can someone point me in the right direction here please ?
cheers,
Adam
Solved! Go to Solution.
Have you taken a look at the IFS() function?
Have you taken a look at the IFS() function?
Thankyou for your direction - I sorted it with IFS() and AND expressions
User | Count |
---|---|
56 | |
25 | |
13 | |
11 | |
6 |