I am working on survey where I would like to have a conditional calculation depending upon a question's answer. Simply put, if the user answers question A, ${A}, with "yes", they answer question B, ${B}; if "no",they answer question C, ${C}. Later, I want to create a confirmation number that, depending upon the value of ${A}, includes ${B} or ${C} (and some additional values in ${D}). I am trying to use the If(condition,x,y) to create the calculation If(${A}='Yes',${B}+${D}, ${C}+$D}). I am getting an error saying the calculation cannot use "If" function.
Is there another way of working this problem? I want to keep the number of extra/junk columns to a minimum.
Any help you can provide is greatly appreciated.
Chris Anderson
Florida Fish and Wildlife Conservation Commission
