Array column creation with if statement?

Forum|Forum|9 years ago
March 23, 2017
3 replies
7338 views

The attached Mathcad Prime 3.1 worksheet (and screenshot) adds a 4th column to the array (or is it a matrix?) with the weight of pipe filled with water per foot. Creating the forth column with a definition works. The if statement tries to accomplish the same goal, what am I doing wrong?

1_Pipe-Question-mcdx.zip

Other

Best answer by Werner_E

Either use a different (dummy) variable instead of w.pipe[i,3 or even better omit the local assignment and use just the right hand side expression on its own.

You should also add an else statement in case a value in the first column is zero.

W

Werner_E

Answer

25-Diamond I

Either use a different (dummy) variable instead of w.pipe[i,3 or even better omit the local assignment and use just the right hand side expression on its own.

You should also add an else statement in case a value in the first column is zero.

-

-MFra-

21-Topaz II

you can do so too:

to which is added the case where w = 0

D

dsochor

Author

1-Visitor

Thank you both very much. F.M. that's a clever way to handle a 1 or 0 Origin.

W

Werner_E

25-Diamond I

Yes, but to be fully ORIGIN-independent one has to change the second indices 0,1,2,3 to ori, ori+1, etc., too. Otherwise you will run into an error in case ORIGIN is not 0.

BTW, here's another way to achieve what you want using the if-command. I changed two values in the first column to zero to show the effect of the "else"-branch.