SyaefulBahri3
6 years agoQrew Trainee
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
------------------------------
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
------------------------------