4 Replies Latest reply on Jun 20, 2012 8:36 PM by PalmDBS

    Using Get or Logical Functions For If/Then

      Evening,

       

      I'm trying to create a calculation that basically says this: if the field "group" contains/says "monkey", then the field name "shortened group name" would contain/say/show "M", if the field "group" contains/says "dog", then the field name "shortened group name" would contain/say/show "D", if the field "group" contains/says "tiger", then the field name "shortened group name" would contain/sayshow "T", and if the field "group" contains/says "human", then the field name "shortened group name" would contain/sayshow "H".

       

      Essentially, I'm trying to say that if a condition/field is met, than "A", if the condition is not met, then look at the condition/field again and if the next condition is met, then "B" and so on.

       

      I hope I am making sense.

       

      I am using FP 8.5.

       

      Thank you for your help:-)

      Adam