Skip to main content
L
LearningENG118-Gravel
8-Gravel
June 26, 2025
Solved

Reassign a Variable Based on a Condition

  • June 26, 2025
  • 2 replies
  • 696 views

I have a ratio based on two variables: e' and d. If this ratio is larger than a condition, I want to assign d' to d and then recalculate the ratio. I want to keep the same variables; I just want the value of d' assigned to d and the ratio above recalculated. Is this possible? I have attached the sheet.

LearningENG11_0-1750967052496.png

 

Best answer by Werner_E

Simply assign the if-statement the variable d. You don't need the local(!) assignment d <-- d'.

Werner_E_0-1750968794458.png

Assignments inside a program always are local assignments and do not affect worksheet variables.

Only way to change a worksheet variable via a program is to assign it the output of a program.

Another way to achieve the same effect is

Werner_E_1-1750968966262.png

A more elaborate way is

Werner_E_2-1750969031367.png

 

 

 

 

2 replies

W
Werner_E25-Diamond IAnswer
25-Diamond I
June 26, 2025

Simply assign the if-statement the variable d. You don't need the local(!) assignment d <-- d'.

Werner_E_0-1750968794458.png

Assignments inside a program always are local assignments and do not affect worksheet variables.

Only way to change a worksheet variable via a program is to assign it the output of a program.

Another way to achieve the same effect is

Werner_E_1-1750968966262.png

A more elaborate way is

Werner_E_2-1750969031367.png

 

 

 

 

    L
    LearningENG118-GravelAuthor
    8-Gravel
    June 26, 2025

    Thank you for the help, much appreciated! I actually ended up doing it a different way, but this works too.

    LearningENG11_0-1750974093518.png

     

    S
    SPaulis14-Alexandrite
    14-Alexandrite
    June 26, 2025

    Hi @LearningENG11 

     

    Here are some addition simplifications you can use:

    SPaulis_0-1750978601509.png

    There is an Excel style "if()" function when you need a bit of brevity.  Also, if you have a lot of basic Y/N or Pass/Fail tests, you can make simple global functions and place them at the end.  It may be helpful because you do not want to have to keep writing the same code over and over and reduces errors and used real-estate.

     

     

    Also, this is a preference of mine so ignore it if you prefer otherwise, I like to show D/C's because not only does it tell you if the check passes, but also how much reserve is left.  So I have a simple global function with gives more focus to the result than the if statements.  I modified your values a bit in the following example to demonstrate,  But these numbers show that the axial is very efficient and moment resistance only needs a bit of tweaking..  The big bold "✖" is a dead giveaway when something is not working 😉

    SPaulis_2-1750979308291.png

    This is my function in case you are curious:

    SPaulis_5-1750979959320.png

     

     

     

     

     

     

     

     

     

      W
      Werner_E25-Diamond I
      25-Diamond I
      June 26, 2025

      It's even shorter if you can do without the explicit “yes” and “no” 😉

      Werner_E_0-1750980550847.png

       

        S
        SPaulis14-Alexandrite
        14-Alexandrite
        July 7, 2025

        Yup, that is even shorter. 

         

        In engineering, we like to put some sort of explicit confirmation, like a text.  You want the reviewer to recognize the common wording that their office employs.  My additional suggestion is that the coding for the 'verbose' result function does not get any more exciting as you review someone's calculation sheet.  And you do not want to bore the reviewer... at least not to death!  That is why a mundane function like that is better suited as a global function and defined at the end.

         

        For future Prime versions, a real True/False number format, like in Excel, could also work in this situation.  I would imagine that custom number formats would be a much, much future feature for Prime.


        Terms & ConditionsCookie settingsAccessibility statement