Nested if Statements in xlsform?

I am trying to do a nested if function in the calculation field......is it possible?

if(cond a,xxx(if cond b,xxx),xxx)

I am a complete noob to this so I am trying to get this to work....thanks for the help in advance.........

Yes, they do!

if(${var}='x_value', 'XXX', if(${var}='y_value', 'YYYY', '{unspecified
value}'))
1 Like

Thanks for the reply.........I will give it a try.

··· On Tuesday, January 21, 2014 6:35:42 PM UTC-7, ニコノコ wrote: > > Yes, they do! > > if(${var}='x_value', 'XXX', if(${var}='y_value', 'YYYY', '{unspecified > value}')) > > > On Tuesday, January 21, 2014, Harper, John <John....@sodexo.com> wrote: > >> > I am trying to do a nested if function in the calculation >> >> > field......is it possible? >> >> > >> >> > >> >> > >> >> > if(cond a,xxx(if cond b,xxx),xxx) >> >> > >> >> >> >> >> >> I am a complete noob to this so I am trying to get this to work....thanks >> for the help in advance......... >> >> ------------------------------ >> This e-mail, attachments included, is confidential. It is intended solely >> for the addressees. If you are not an intended recipient, any use, copy or >> diffusion, even partial of this message is prohibited. Please delete it and >> notify the sender immediately. Since the integrity of this message cannot >> be guaranteed on the Internet, SODEXO cannot therefore be considered liable >> for its content. >> >> Ce message, pieces jointes incluses, est confidentiel. Il est etabli a >> l'attention exclusive de ses destinataires. Si vous n'etes pas un >> destinataire, toute utilisation, copie ou diffusion, meme partielle de ce >> message est interdite. Merci de le detruire et d'en avertir immediatement >> l'expediteur. L'integrite de ce message ne pouvant etre garantie sur >> Internet, SODEXO ne peut etre tenu responsable de son contenu. >> >> -- >> -- >> Post: opendatakit@googlegroups.com >> Unsubscribe: opendatakit+unsubscribe@googlegroups.com >> Options: http://groups.google.com/group/opendatakit?hl=en >> >> --- >> You received this message because you are subscribed to the Google Groups >> "ODK Community" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to opendatakit+unsubscribe@googlegroups.com. >> For more options, visit https://groups.google.com/groups/opt_out. >> > > > -- > -- > Nik > Need help customizing Survey Instruments/Tools/Forms for ODK Collect? Drop > me an email. > >

Hello @John_Harper , did it work for you?*