Forum Discussion

RoxanneZiegler's avatar
RoxanneZiegler
Qrew Assistant Captain
8 months ago
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...
formulas
  • RoxanneZiegler's avatar
    RoxanneZiegler
    7 months ago

    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

RoxanneZiegler's avatar
RoxanneZiegler
Qrew Assistant Captain
8 months ago

The comma before the 0 is yellow. 

I did get this to sort of work 

If([Sale]="yes",[Manifest price w/o iva],([Sale]="Cancel"),(0))

The cancel ones are 0 however there are no other prices from manifest price in there

 

MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
8 months ago

Can you try my suggested Syntax?

IF(

[Sale]="yes",[Manifest price w/o iva],

[Sale]="Cancel",0)