Discussions

Expand all | Collapse all

If Then formula help

  • 1.  If Then formula help

    Posted 03-25-2018 18:55
    I need help with an If then statement.  I would like a formula that says If the [Inventory Number Field] is blank then use the value from the [Asset Number] field.


  • 2.  RE: If Then formula help

    Posted 03-25-2018 20:50
    The answer depends on he field type of the [Inventory Number Field]

    If it is a numeric field type and the setting is to treat blank as zero, then use:

    IF([Inventory Number Field]<>0, [Inventory Number Field], [Asset Number])

    If the [Inventory Number Field] is a numeric field but the setting is unchecked so not to treat blank as zero, then use :

    IF(not IsNull([Inventory Number Field]), [Inventory Number Field], [Asset Number])

    and lastly if the field is in fact a text field type then use:

    IF(Trim([Inventory Number Field])<>"", [Inventory Number Field], [Asset Number)


  • 3.  RE: If Then formula help

    Posted 03-27-2018 14:39
    Thank You!  The text Field solution is exactly what I needed!