Hi , why appsheet canโt read this formula , is there something wrong ???
OR
(
if([categorie1]=Optique,โMontureโ,""),
if([categorie1]=Solaire,โMontureโ,"")
)
Solved! Go to Solution.
Hi @Soufiane_M
Something like that ?
IF(
OR([categorie1]="Solaire",
[categorie1]="Optique"),
"Monture",
"")
Youโre using OR() wrong.
See also:
I read that topic ,I can do simple formulas , but now am trying to apply it with an IF function more complicated which is not explained in the topic .But I unfortunately I get always an error I want to find it out
ORs return a true/false(yes/no). Your if formulas return text values. I think what you want is IF(OR(โฆ), Monture,"") or you could use an IFS().
I want a formula which will return text values โMontureโ in two cases :
if([categorie1]=Optique,โMontureโ,"") OR if([categorie1]=Solaire,โMontureโ,"")
Hi @Soufiane_M
Something like that ?
IF(
OR([categorie1]="Solaire",
[categorie1]="Optique"),
"Monture",
"")
GREAT , thatโs the solution for my question it works when only one returnes Thank youu , but now what if I multiple returnes for exemple :
if [categorie1]=โoptiqueโ retunes โmontureโ
or
if [categorie1]=โSolaireโ retunes โsolaireโ
??
Please have a look to the article about โSWITCHโ
Great hopefully I find this tutorial on Youtube explain well the SWITCH FUNCTION AppSheet SWITCH() Expression - YouTube Thank you very much guys
User | Count |
---|---|
36 | |
33 | |
27 | |
23 | |
18 |