RoxanneZiegler
5 days agoQrew Cadet
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 show" "and but if"
Edit
I got some of that formula to work
If([Sale]="yes",[Manifest price w/o iva],([Sale]="Cancel"),(0))
all it give me is the Cancel ones at 0
The manifest price one is blank
Edit - Solved by AI Chatgpt
If(Trim([Sale])="Yes",[Manifest price w/o iva],Trim([Sale])="Cancel",0,0)//Default value if[Sale]is neither "yes"nor "cancel"