Solved
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...
no it always came up yellow - the only one that worked in this case was
If(Trim([Sale])="Yes",[Manifest price w/o iva],Trim([Sale])="Cancel",0,0)//Default value if[Sale]is neither "yes"nor "cancel"
Thank you so much
