Discussions

Expand all | Collapse all

Not equal to in formula text

Jump to Best Answer
  • 1.  Not equal to in formula text

    Posted 18 days ago
    Hi All,

    What is not equal to equivalent for formula field?. Try to put ≠ but is not working since I just think the sign = is mean equal to

    This is my formula text example
    If(
    [Supplier]="Other supplier", "Please attach 3 Quotation",
    [Supplier]≠"Other supplier", "Please attach purchase order")

    Many thank



    ------------------------------
    Syaeful Bahri
    ------------------------------


  • 2.  RE: Not equal to in formula text

    Posted 18 days ago
    You can use <>. Two symbols 

    like

    If(
    [Supplier]="Other supplier", "Please attach 3 Quotation",
    [Supplier]<>"Other supplier", "Please attach purchase order")




    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    markshnier2@gmail.com
    ------------------------------



  • 3.  RE: Not equal to in formula text
    Best Answer

    Posted 18 days ago
    Syaeful,

    For this formula you do not need the "Not Equal"

    If ([Supplier]="Other Supplier", "Please attach 3 Quotation", "Please attache purchase order")

    However the syntax for "Not Equal"  is <>


    ------------------------------
    Don Larson
    Paasporter
    Westlake OH
    ------------------------------



  • 4.  RE: Not equal to in formula text

    Posted 18 days ago
    It's working. Thanks Don

    ------------------------------
    Syaeful Bahri
    ------------------------------