Microvellum Knowledge Network

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.

    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:

               

        Google Review