Convert excel code if condition to kobo code

[masalafortunat]

Hello dear colleague, I hope you are well.

Need your support, I have an excel formula that I placed in column C2 to increment it later, this formula allows you to have “yes” if at least one column has a “yes” and "no " if both columns (A and B) have a “no” each, similarly “empty” if columns (A and B) are empty.
The formula looks like this: =IFERROR(IF.CONDITIONS(OR(A2=“yes”;B2=“yes”);“yes”;OR(A2=“no”;B2=“no”);“no “);””)

I wanted to convert this code into the kobo language to put it in calculate

[osmanburcu]

Hi @masalafortunat, Please check this formula and let me know if it is working for you

if((${A} = “yes” or ${B} = “yes”),“Yes”,if((${A} = “no” or ${B} = “no”),“No”,“”))

a6uPoSbx9CURrGUvUnUfHS.xlsx (6.4 KB)

[Kal_Lam]

@osmanburcu,

[Kal_Lam]

@masalafortunat, you should be able to learn about if-statement through this previous post:

When is if() function used in formbuilding?

You could use the if() statement when you have to assign a certain value/expression for a certain condition else use another value/expression. Thus, the if statements require three arguments: a condition; the result if the condition is true; and the result if the condition is false. The syntax would be as follows: if(condtion,value,value) if(condtion,expression,expression) if(condtion,value,expression) if(condtion,expression,value) You could learn more about the if-statement by following o…

These posts discussed previously should also be able to help you understand how it’s used.

[masalafortunat]

Hello @osmanburcu thank you for your support, your Kobo formula is correct and worked well.

[masalafortunat]

Thank you @Kal_Lam for this orientation.