2 Replies Latest reply on Jul 14, 2015 1:30 PM by BradWieland

    Help with IF or CASE function

    BradWieland

      Title

      Help with IF or CASE function

      Post

      I need help creating a formula for this. I'm assuming this will be a nested IF or CASE function?

      In English:

      if the response to a radio button is "yes", and if 
      the value selected from the drop-down value list in a field called <Name 02_age> is age "0-4", then yield the cost result from a field named <rate_lunch_0_4>

      OR

      if the response to a radio button is "yes", and if 
      the value selected from the drop-down value list in a field called <Name 02_age> is age "5-11", then yield the cost result from a field named <rate_lunch_5_11>

      OR

      if the response to a radio button is "yes", and if 
      the value selected from the drop-down value list in a field called <Name 02_age> is age "12up", then yield the cost result from a field named <rate_lunch_12up>

      Does this make sense? I appreciate any help someone can give me.