Skip to main content
G
Gunjac1-Visitor
1-Visitor
July 10, 2014
Question

Multiplying values inside a mathcad table

  • July 10, 2014
  • 9 replies
  • 8975 views

Hi folks!

Is there ny way to multiply values inside Mathcad table like its done in Excel?

See file attached.

Thanx

9 replies

F
Fred_Kohlhepp23-Emerald I
23-Emerald I
July 10, 2014

You cannot attach an equation to a cell in a mathcad table, the table is either input or a place to display results or output. You can embed an EXCEL sheet in Mathcad and do what you're asking.

G
Gunjac1-VisitorAuthor
1-Visitor
July 10, 2014

Sound interesting but I would like to do all in one place.

What you said mean that I must manipulate tablein Excel and then import it in Mathcad, right?

F
Fred_Kohlhepp23-Emerald I
23-Emerald I
July 10, 2014

No, you can put an EXCEL sheet (fully functional) into the Mathcad document.

Werner_E
Werner_E25-Diamond I
25-Diamond I
July 10, 2014

Why would you want to use Excel's cell manipulations when you can have Mathcad's calculation with meaningful variable names and units, too??

T
Tezza20101-Visitor
1-Visitor
August 9, 2014

Hi Mario,

Yes there is a way to put the last column in as you require.

The table creates a variable called "lay".

What is done here is create a new variable called "output".

You first extract the columns you need.

Do the arithmatic on the extracted columns in an element by element fashion (With one vectorised expression)

Then reassemble the required individual columns with the "augment" function.

Have enclosed a file that does this as an extension of the one provided.

If required you can set the assign the original "lay" to the new values "output"

Hope it helps.

Terms & ConditionsAccessibility statement