Not equal to in formula text

Question

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 toThis is my formula text exampleIf([Supplier]="Other supplier", "Please attach 3 Quotation",[Supplier]≠"Other supplier", "Please attach purchase order")Many thank------------------------------Syaeful Bahri------------------------------

DonLarson · Accepted Answer

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 LarsonPaasporterWestlake OH------------------------------

MarkShnierYou · Answer

You can use <>. Two symbols likeIf([Supplier]="Other supplier", "Please attach 3 Quotation",[Supplier]<>"Other supplier", "Please attach purchase order")------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commarkshnier2@gmail.com------------------------------

Sign up

Login to the community