AnsweredAssumed Answered

Help with IF or CASE function

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

 

 

Outcomes