If Then Else If Then Else If...

[Former Member]

I want to do something like this...

IF W <> 0 AND X <> 0 THEN Y/A ELSE IF W <> 0 AND X == 0 THEN Z/A

I can do an IF THEN for the first part IF W <> 0 AND X <> 0 THEN Y/A

I can do an IF THEN for the second part W <> 0 AND X == 0 THEN Z/A

The problem is, when I try to put them into a single statement, I don't know what to put inbetween the two If thens.

[Former Member]

Right now I have...

 (( W <> 0) AND (X <> 0) * Y/A + ((W <> 0) AND (X == 0)) * Z/A 

This doesn't work. I get ones, zeroes, or Xs.

[Former Member]

I'm not sure why the signs for less than and greater than together signifying NOT EQUAL aren't ashowing up, but there should be NOT EQUAL where there are missing operators.

[Former Member]

Lastly, I know I could make a CKF for each and then make a third adding the two together, but that seems like a long way to go.

[Former Member]

I answered my own question. I was getting Xs because I wasn't using NODIV(x). Closed

Edited by: Flinger on Apr 20, 2011 3:16 PM