AnsweredAssumed Answered


Question asked by LauraJones on Apr 14, 2015
Latest reply on Apr 14, 2015 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.