Microvellum Community

Vector Location Formula Syntax

Hello,

I am trying to modify a vector location formula and can't get the syntax correct.  I have a custom countertop product that routes a scribe relief along the back edge of a 1-1/8 sub material. My problem is that this route remains constant no matter if finished right end or finished left end is selected the route continues to be +/- 0.25 the product length. I am trying to add IF statements for starting and ending the route 2 inches inside of the finished ends.

The original formula:

="-.25;"&Panel_Width-Scribe_Width&";"&Scribe_Depth&"|0;"&Panel_Width-Scribe_Width&";"&Scribe_Depth&"|"&Panel_Length&";"&Panel_Width-Scribe_Width&";"&Scribe_Depth&"|"&Panel_Length+0.25&";"&Panel_Width-Scribe_Width&";"&Scribe_Depth

This is what I would like to add to the formula;
Starting X location IF(Left_Fin_End=1,2,-.25)
The next X location  IF(Left_Fin_End=1,2,0)
The third X location to be IF(Right_Fin_End=1, Panel_Length-2,Panel_Length)
The final X location would be IF(Right_Fin End=1,Panel_Length-2, Panel_Length+0.25)

Thank you in advance for shedding some light on this.

    Toolbox BSB Survey



    Have you been using Toolbox BSB? We'd love to hear what you think!

    Take the Survey

      MVU eLearning



      Grow Your Knowledge
      Follow along with RJ as he takes you on a journey to build your foundational knowledge of Toolbox.


        Follow us on:

                 

          ERP for Millwork Shops


          Discover how Microvellum and INNERGY streamline operations for cabinet shops and millwork manufacturers.