Skip to main content
3-Newcomer
June 15, 2026
Question

If and Else operations for Table

  • June 15, 2026
  • 2 replies
  • 42 views

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?

 

2 replies

19-Tanzanite
June 15, 2026

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

Alan.

Milind3-NewcomerAuthor
3-Newcomer
June 16, 2026

Thank you very much

21-Topaz II
June 15, 2026

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

Cheers

Terry