Hi @Kal_Lam
I just uploaded the excel file having some functions we used.
Test.XLSX (23.3 KB)
Hi @rahmat,
The file you shared does not help me. I would appreciate if you could list out some conditions along with a dummy question and options so that we could help you out as how it looks in the xlsform.
Have a great day!
Dear @Kal_Lam
Before, I share the question and conditions, can you give me an example of below statements used in a calculation in XLSForm? I may be able to figer out.
If statement used ALONE
IF and OR statements used in a calculation
IF, OR, AND statements used together in a calculation.
thanks
rahmat
Hi @rahmat,
Here are some workarounds that has been discussed in the community previously. Would you mind checking them out. It should solve your issue.
Have a great day!
Hi @rahmat,
The if condition is already there in the xlsform. Have you checked it out?
Have a great day!
Yes but it is not giving the result I want.
Hi @rahmat,
So please try to being specific on what you wish to see or have. That would only be the way-out for your solution. We thus need a small description of what you require so that we would be able to support.
Have a great day!
Hi team, I understand his question correctly. @rahmat wanted to use that formula a indicator of food security.
This is the formula in excel =IF(G7<=28,“Faible”,IF(AND(G7>28,G7<=42),“Limite”,“Acceptable”))
That formula will be apply on a calculated field in kobo to make a decision of the status of householder regarding their score.
Hi
I need to know what exactly are the conditions you need for me to be able to execute this.
Also confirm if this worked for you
Stephane
1 Like
Dear @stephanealoo
As in excel we have several functions/formulas such as IF, OR, AND.
I want to apply the same formulas in Kobo and when collecting data, at the end of the form, the data collectors will know whether the interviewee is eligible for assistance or Not. Thus, I want to use a formula like:
=IF(OR(BH2=“Poor”,BH2=“Borderline”,),3,0)
In conclusion, once the form is completed in KoboCollect, the data collector will enderstand, whether the interviewee is eligible or not. We have several other functions but once we solve this one, we can applly others ourselves.
Best
Rahmat
I believe you are familiar with writing complex calculations as explained in our article here
However for specifics about the question you are asking
You can use double if to execute the OR functionality. i.e.
=if(${BH2}=“Poor”,3,(if(${BH2}=“Borderline”,3,0)))
or
You can use
=if((${BH2}=“Poor” or ${BH2}=“Borderline”),3,0)
Stephane
2 Likes
Thank you very much @stephanealoo
Can you also give an example for below function as there we have IF, AND, OR together?
=IF(OR(AND(AT4=“Low”, AM4=“Poor”), AND(AT4=“Medium”, AM4=“Borderline”), AND(AT4=“High”, AM4=“Acceptable”)), “Moderately”, “Food”)))
Rahmat
Try this
=if(((${AT4}=“Low” and ${AM4}=“Poor”) or (${AT4}=“Medium” and ${AM4}=“Borderline”) or (${AT4}=“High” and ${AM4}=“Acceptable”)), “Moderately”, “Food”)
Thank you very much. will definately try this and update you accordingly. Once these things work, I will prepare a good excel file with all these formulas in excel and Kobo and upload here for other friends 
Hi,
This one =if(${BH2}=‘Poor’,3,(if(${BH2}=‘Borderline’,3,0))) WORKED 
2 Likes
I am trying to check the value of 2 calculations like total number of staff and the breakdown of that total number of staff by cadre, I want to know which syntax I will use so that when the 2 figures are not equal, it will prompt error message
@aogugua, could you share a dummy question and your condition for this? Maybe the community should be able to help you out looking at the same.
koboform.xlsx (9.8 KB)
the comment is not part of the form, I just inserted it there to explain what I want
As a worksheet function, the IF function can be entered as part of a formula in a cell of a worksheet. It is possible to nest multiple IF functions within one Excel formula for Excel with 4 outcomes. You can nest up to 7 IF functions to create a complex IF THEN ELSE statement.
