I want to add beam section profiles to an excel list to expand the calculation options for this sheet.
I have added the beams that I want, but now i must add and in a new "if" statement to the bottom of each variable selection list. How do i do this?.
Solved! Go to Solution.
but now i must add and in a new "if" statement to the bottom of each variable selection list. How do i do this?.
Not sure what the problem is - you do it the same way as you had already added the other 13 if-statements!? You put the cursor at the end of the last program line and press Shift-Enter to create a new line. Then you type "if" (without the quotes) and immediately press Ctrl-J or you use the menu to insert an additional if-statement.
To avoid that long list if if's you might have a look at Primes various "lookup" functions. Especially "vlookup" seems to come quite handy for your problem - let Prime lookup the name in the first column of your table and return the appropriate value in the Area- or diameter-column.
but now i must add and in a new "if" statement to the bottom of each variable selection list. How do i do this?.
Not sure what the problem is - you do it the same way as you had already added the other 13 if-statements!? You put the cursor at the end of the last program line and press Shift-Enter to create a new line. Then you type "if" (without the quotes) and immediately press Ctrl-J or you use the menu to insert an additional if-statement.
To avoid that long list if if's you might have a look at Primes various "lookup" functions. Especially "vlookup" seems to come quite handy for your problem - let Prime lookup the name in the first column of your table and return the appropriate value in the Area- or diameter-column.
This sheet was the template that I used to make the new sheet.
I got this sheet from a coworker and I did not make it myself so this was an issue of learning both how Mathcad worked as well as the differences between Mathcad 15 and 4.0