Skip to main content
Solved

syntax help with formula

  • March 26, 2025
  • 0 replies
  • 360 views
Forum|alt.badge.img+8

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"

 

 

 

 

 

 

Best answer by RoxanneZiegler

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

MarkShnierYou
Forum|alt.badge.img+24

Try this

IF(

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

[Sale]="Cancel",0)

 

Mark Shnier. Your Quickbase Coach
Forum|alt.badge.img+8

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

 

Forum|alt.badge.img+8

Hi Mark

Yes I did try and it didn't work. The field came out blank. 

Forum|alt.badge.img+8
  • RoxanneZiegler
  • Author
  • Registered
  • Answer
  • April 3, 2025

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

Terms & ConditionsAccessibility statement