I need help writing a calculation that will create different values based on several different conditions in another field. I have tried using the "case" function but it doesn't make it clear how to refer to the other field. I've tried simple calculation such as
=19 IF (field name) < 20
but this doesn't work and I then wouldn't know how to enter several conditions. What I need the calculation to do is: =19 if the other field <20, =9 if other field >/=20 and </=29, and =0 if other field >/=30.
I assume this is something simple to do but I haven't worked with this type of thing before.