If statement using numeric formula fields.
I am trying to create a Text Formula field that will pull information from three different numeric formula fields. If 1st one is not equal to null, pull the information from 1st field, if the 2nd one ...
Forum Discussion
Try something like this:
If(not IsNull([Field 1]), [Field 1], not IsNull([Field 2]), [Field 2], not IsNull([Field 3]), [Field 3])
------------------------------
Paul Peterson
------------------------------
If(not IsNull([Field 1]), [Field 1], not IsNull([Field 2]), [Field 2], not IsNull([Field 3]), [Field 3])
------------------------------
Paul Peterson
------------------------------
Thank you! This works perfectly!
------------------------------
Nicole Varner
------------------------------
------------------------------
Nicole Varner
------------------------------