How to create a formula with if() and()

[Soufiane_M]

Hi guys why that gives error

IF(And(
[phot1], “x”, “A”),
([phot2], “x”, “B”)
)

Condition AND([phot1], “x”, “A”) has an invalid structure: subexpressions must be Yes/No conditions

[Steve · Accepted solution]

That’s because your expression makes no sense. Using plain language, please explain what you’re tying to do.

See also:

help.appsheet.com

AND()

Are all true?

help.appsheet.com

IF()

Either/or conditional evaluation