Skip to main content
K
kgullner1-Visitor
1-Visitor
March 21, 2017
Solved

IF statement for references

  • March 21, 2017
  • 12 replies
  • 4032 views

Can i make a IF statement for my references? Say if true reference1 is active, and if false, reference2 is active.

If not, can i perhaps use VB for programming it?

Thanks!

Best answer by -MFra-


I think that it is impossible. All that you can do (Mathcad 15) is represented in the following  picture that I hope is understandable:

About references.jpg

In the worksheet A, you can add all the reference you want, you have to ensure that in each of them there are not the same references.

You can call functions and programs from user defined DDL added to mathcad.

12 replies

-
-MFra-21-Topaz IIAnswer
21-Topaz II
March 21, 2017


I think that it is impossible. All that you can do (Mathcad 15) is represented in the following  picture that I hope is understandable:

About references.jpg

In the worksheet A, you can add all the reference you want, you have to ensure that in each of them there are not the same references.

You can call functions and programs from user defined DDL added to mathcad.

D
DJF16-Pearl
16-Pearl
March 21, 2017

I'm not really sure what you are after, but it sounds like a lookup table might work.  something like this:

lookup1.jpg

L
LucMeekes23-Emerald IV
23-Emerald IV
March 22, 2017

Mathcad does not support conditional references, nor does Prime.

What version of Mathcad (or Prime) do you (want to) use?

Depending on what kind of information you wanted to put in the alternative references, there may be better ways.

Luc

K
kgullner1-VisitorAuthor
1-Visitor
March 22, 2017

Hi, thanks for all answers.

The version is Mathcad 15. I am trying to isolate different calculations. For example: I know how to calculate crack width for concrete. I also know how to calculate the number of reinfocement bars for concrete, depending on moment and shear forces. But, i dont want to perform/have all calculations in one sheet. Instead i want to be able to call for the calculations. So the different calculations are modules in some way.

-
-MFra-21-Topaz II
21-Topaz II
March 23, 2017

Hi,

Create your worksheets independently of each other, and use the references in the main worksheet, observing my diagram provided earlier. You can not redefine programs, variables and constants defined in other worksheets that are part of  the references, you can only call them in the main worksheet. Otherwise you can expect freezing the computer.

Terms & ConditionsAccessibility statement