Updating numeric field based on a number range

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

Have you taken a look at the IFS() function?

3 Likes

Thankyou for your direction - I sorted it with IFS() and AND expressions

2 Likes