syntax help with formula
I am making a formula and I am having trouble with syntax I want the statement to say If([Sale]="Yes", than show [Manifest Price] but if ([sale]="cancelled" show 0.00) I need the syntax for "than...
Forum Discussion
Hi Mark
Yes I did try and it didn't work. The field came out blank.
MarkShnier__You
Qrew Legend
Qrew LegendSorry use this. The Yes is case sensitive
IF(
[Sale]="Yes",[Manifest price w/o iva],
[Sale]="Cancel",0)
.. assuming that the value in the field sales is Yes and not yes..