Using multiple IFS statements or is there a different way?

[Tiger1]

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.

[JuneCorpuz · Accepted solution]

Use AND() Formula.

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

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

[Tiger1]

Yet again you have saved me!

Thanks again