Skip to main content
Question

Formula error

Forum|alt.badge.img+11

Please help me make this work...thx

If(
[BUDGET.030123]=true,
[Job - Copy of Related Projects - Window Wrap-0 Sides]=true,
([Related Priced Spec2 - Related MPS2 - Corner Bead1-1/4X9' Metal/Box $]*0.65),
[Job - Copy of Related Projects - Window Wrap-3 Sides]=true,
([Related Priced Spec2 - Related MPS2 - Corner Bead1-1/4X9' Metal/Box $]*0.85),
[Job - Copy of Related Projects - Window Wrap-4 Sides]=true,
([Related Priced Spec2 - Related MPS2 - Corner Bead1-1/4X9' Metal/Box $]*1),


[Job - Copy of Related Projects - Window Wrap-0 Sides]=true,
([Related Priced Spec2 - MPS - ID-Corner Bead1-1/4X9' Metal/Box $]*0.65),
[Job - Copy of Related Projects - Window Wrap-3 Sides]=true,
([Related Priced Spec2 - MPS - ID-Corner Bead1-1/4X9' Metal/Box $]*0.85),
[Job - Copy of Related Projects - Window Wrap-4 Sides]=true,
([Related Priced Spec2 - MPS - ID-Corner Bead1-1/4X9' Metal/Box $]*1)

)



------------------------------
BuildPro
------------------------------
    This topic has been closed for replies.

    It looks like you're trying to chain together multiple pieces in the IF criteria, but the way that you're doing it won't work. Here's what I'm seeing:

    IF(Criteria 1, Criteria 2, Then,

         Criteria 3, Then,

         Criteria 4, Then,

         Criteria 5, Then,

         Criteria 6, Then,

         Criteria 7, Then)

    If you want to have Criteria 1 and 2 be required for the first Then, that would be:

    IF(Criteria 1 AND Criteria 2, Then,

         Criteria 3, Then,

         Criteria 4, Then,

         Criteria 5, Then,

         Criteria 6, Then,

         Criteria 7, Then)



    ------------------------------
    Blake Harrison
    bharrison@datablender.io
    /
    ------------------------------
    Terms & ConditionsAccessibility statement