Skip to main content
3-Newcomer
Jun 15, 2026 11:08 AM UTC
Solved

If and Else operations for Table

I have created an Excel document in which I calculated the start and end coordinates for strips. The total number of strips is 23. I generated the strip data using table options in Mathcad.

Now, I want to perform the same calculation for strip start and end coordinates directly in Mathcad. Please refer to the calculation used in cell F42 in Excel. How can I replicate this equation in Mathcad?

 

19-Tanzanite
Jun 15, 2026 12:46 PM UTC

Here’s a close translation into Mathcad Prime (using version 12).  (There are alternative ways).

Alan.

3 replies

19-Tanzanite
Jun 15, 2026 12:46 PM UTC

Here’s a close translation into Mathcad Prime (using version 12).  (There are alternative ways).

Alan.

Translate
Milind3-NewcomerAuthor
3-Newcomer
Jun 16, 2026 3:42 AM UTC

Thank you very much

Translate
terryhendicott
21-Topaz II
Jun 15, 2026 10:39 PM UTC

Please upload a zipped up version of your excel file. Then it is possible to reproduce the whole sheet in Prime.

Cheers

Terry

Translate