Using Excel formulas in an XLSFORM

[Kal_Lam]

@aristidey, try using the substring function as outlined in this community post discussed previously and that should solve your issue:

Round to next higher integer (e.g. 1.2 to 2)

@mandarsathe, if this is the requirement, you could do it as outlined in the image shared below: In the survey tab of your xlsform: [Image 1] Data entry screen as seen in Enketo: [Image 2] Data entry screen as seen in Enketo: [Image 3] Reference xlsform: substring-before substring-after.xlsx (9.5 KB)