Skip to Content
Former Member
Apr 24, 2007 at 08:05 PM

Correctly using isnull()


Post Author: WAFFLE

CA Forum: Formula

I want to create a formula that checks to see if something is null and if it is, I want it to check another piece of information. If it does have information I want it to return the information.So what I was thinking was IF NOT isnull(field1) then field1 else IF NOT isnull(field2) then field2 else IF NOT isnull(field3) then field3 else " ";Is this thought process off or is this the best way to go about it?