Chained IF THEN statement

nick22

Hi everyone,

I am in need of some help in writing a chained IF THEN.

I have four fields. I need the IF THEN to look at field one, then if field one is not null take that number otherwise move to field two. and so one down the line for the four fields.

Here is what I have for a formula now:

IF IsNull([Quote - Grand Total (converted)])
THEN [Quote - Grand Total (converted)]
ELSEIF IsNull([Quote - Grand Total w/ PEV (converted)])
THEN [Quote - Grand Total w/ PEV (converted)]
ELSEIF IsNull([Grand Total (converted)])
THEN [Grand Total (converted)]
ELSEIF IsNull([Total Product and PEV (converted)])
THEN [Total Product and PEV (converted)]
ELSE 0
ENDIF

currently this returns a 0.

Any suggestions?

NicoleJohnson

If you are trying to return the value only if the field is not Null, then I think you just need to add an ! in front of each IsNull statement (which makes it "If is not null" rather than "If is null").

IF !IsNull([Quote - Grand Total (converted)])
THEN [Quote - Grand Total (converted)]
ELSEIF !IsNull([Quote - Grand Total w/ PEV (converted)])
THEN [Quote - Grand Total w/ PEV (converted)]
ELSEIF !IsNull([Grand Total (converted)])
THEN [Grand Total (converted)]
ELSEIF !IsNull([Total Product and PEV (converted)])
THEN [Total Product and PEV (converted)]
ELSE 0
ENDIF

Let me know if that does the trick!

NJ