PaulElliott

2 years agoQrew Member

Solved

# If then questions

I have a series of If conditions I want to figure out but am getting a boolean error at the end of the statement.

If([FC Shake Type2]="Staggered Shake", [Actual Shake Siding], //Condition 1

if([FC Shake Type2]="Straight Shake",0, //Condition 2

if([City Set Shake Type]="Staggered Shake",[Actual Shake Siding], //Condition 3

if([Bid Set Shake Type]="Staggered Shake",[Actual Shake Siding],0),0)),0)

Screenshot of formula

Error Message:

Just wondering where I went wrong in the formula, it looks right to me but there's the error saying I'm wrong.

------------------------------

Paul Elliott

------------------------------

- In Quickbase syntax it's simpler than excel. Just list your conditions vertically with just one IF. But also this is a formula text field type so you cannot have a numeric 0 as a result. Hence I added quotes around the 0.

If(

[FC Shake Type2]="Staggered Shake", [Actual Shake Siding], //Condition 1

[FC Shake Type2]="Straight Shake","0", //Condition 2

[City Set Shake Type]="Staggered Shake",[Actual Shake Siding], //Condition 3

[Bid Set Shake Type]="Staggered Shake",[Actual Shake Siding],"0")

------------------------------

Mark Shnier (YQC)

mark.shnier@gmail.com

------------------------------