Nested IF Based on two cummulative conditions

Anonymous — Sun, 02 Oct 2022 07:44:51 GMT

Hello,

I have this table:

Now I want to create a Status column that basically follows the assumptions below:

- Criteria 1 threshold = 100%

- Criteria 2 threshold = 0%

- If one the above assumptions doesn't follow the threshold we should mark the line as Rejected

Example of my goal:

Can you please help me?

I'm trying with this, but no success so far

PO Status = VAR one_ = [Criteria 1] VAR two_ = [Criteria 2] RETURN IF(ISBLANK(one_) || one_ < 1,IF(two_ > 0,"Rejected","Accepted"))

Re: Nested IF Based on two cummulative conditions

tamerj1 — Sun, 02 Oct 2022 09:00:49 GMT

Hi Anonymous
Please try

PO Status = VAR one_ = [Criteria 1] VAR two_ = [Criteria 2] RETURN IF ( one_ < 1 || two_ > 0, "Rejected", "Accepted" )

Anonymous — Sun, 02 Oct 2022 11:28:06 GMT

So simple and so effective. Many thanks !!