2 Replies Latest reply on Apr 14, 2015 6:31 AM by LauraJones






      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.