Forum Discussion

SyaefulBahri3's avatar
SyaefulBahri3
Qrew Trainee
5 years ago
Solved

Not equal to in formula text

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
------------------------------
  • 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
    ------------------------------

3 Replies

  • 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
    ------------------------------
  • DonLarson's avatar
    DonLarson
    Qrew Commander
    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
    ------------------------------
    • SyaefulBahri3's avatar
      SyaefulBahri3
      Qrew Trainee
      It's working. Thanks Don

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