Discussions

 View Only
  • 1.  If then questions

    Posted 06-22-2022 11:56

    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
    ------------------------------


  • 2.  RE: If then questions
    Best Answer

    Posted 06-22-2022 12:12
    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
    ------------------------------



  • 3.  RE: If then questions

    Posted 06-22-2022 12:36
    That worked.  I put the Straight Shake condition first and then looked at the others.

    Thank you again for your help, actually this solves a multitude of problems as I've been hitting similar errors which I can apply the same logic to.

    ------------------------------
    Paul Elliott
    ------------------------------