IF criteria transform into date

[baba_sawane]

Hi experts of Appsheet,

I'm trying to express a formula that will show a conditional value within the form, based on user choice in a form.

No problem with the results of the first and third if, but with the 2nd that contain a decimal, it won't work.

This is the formula :

If([Epaisseur Géomembrane PeHD (en mm)] = "1",4,
if([Epaisseur Géomembrane PeHD (en mm)] = "1 .5",6,
if([Epaisseur Géomembrane PeHD (en mm)] = "2",8,"")))

And this is the column concerned

Can anyone help me to fix this please?

[Steve · Accepted solution]

Don't put quotes around values to be taken as numeric.

[baba_sawane]

Thank you very much 🙂