Using multiple IFS statements or is there a different way?

AppSheet AppSheet Q&A
1

I need an expression to check multiple IFS and i cannot figure it out. What I have so far:

IFS((
([Antigen Results] <> “Positive”),
([PCR Results] <> “Positive”),
“CLEAR”,

([Antigen Results] = “Positive”),
([PCR Results] = “Positive”),
“ACTIVE”),
TRUE)

I want this expression to check multiple values and give a text value accordingly.

2

Use AND() Formula.

IF(
AND(
[Antigen Results] <> “Positive”,
[PCR Results] <> “Positive”),
“CLEAR”,

IF(
AND(
[Antigen Results] = “Positive”,
[PCR Results] = “Positive”),
“ACTIVE”,
“”))

1 Like
3

Yet again you have saved me!

Thanks again

1 Like