Updating numeric field based on a number range

AY2450
Participant II

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 Solved
0 2 126
1 ACCEPTED SOLUTION

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

View solution in original post

2 REPLIES 2

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

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

Top Labels in this Space