AnsweredAssumed Answered

Nested if statements, can I do an else if

Question asked by abekearl on Sep 25, 2018
Latest reply on Sep 25, 2018 by TimCarmichael

I am making an analysis in AF and I want to select an output that could be one of three things depending on what information is coming in. I am used to doing this in excel, but not in this slightly different function language.

What would be the correct way to say something like the following.

Anytime attribute 1 is good, I want to bring in data directly.

If attribute 1 is bad, then I check attribute 2 and depending on if that is bad I either substitute a zero in place of the incoming data, or I tell pi not to record the data.

So I have done a test previously for Attribute 1 and Attribute 2. Attribute 3 is the value I actually want to record if it is good

 

IF(att 1 = 1) then(Att 3) ELSE(IF(Att 1 = 0 AND Att 2 = 0) THEN 0  ELSE (nooutput())

 

I am open to other methods of doing this completely.

Outcomes