Excel comands on MathCAD
Excel comands on MathCAD
(OP)
Hi!, i have a few questions:
1)I would like to use the command "vlookup" o "hlookup" on MathCAD, is there any way to put or use that on MathCAD?
2)In Excel if a put an answer, lets say:
="Use "&A1&" feet diameter bolt"
(where A1 is the cell that contains a number)
Now, how can i make that with MathCAD?
Thanks for any help!! :)
1)I would like to use the command "vlookup" o "hlookup" on MathCAD, is there any way to put or use that on MathCAD?
2)In Excel if a put an answer, lets say:
="Use "&A1&" feet diameter bolt"
(where A1 is the cell that contains a number)
Now, how can i make that with MathCAD?
Thanks for any help!! :)
RE: Excel comands on MathCAD
You could insert a math region in the middle of the text string, but I find that it makes editing and future maintenance of the worksheet harder.
Q1 - I think you may have to write your own function to extract data from an array, using the in-built array indexing functions, if your data is table-based like Excel. Or just use an Excel component in Mathcad, and do all the lookup things inside it.
Bung
Life is non-linear...
RE: Excel comands on MathCAD
Bung
Life is non-linear...
RE: Excel comands on MathCAD
Q2 - I don't see it, can you put a expression to see? because as i understand you are saying that will end up something like this:
--> The answer is:
Bolt:=0.25in (let's say i put this inside an area so it won't show)
--> Now at the end of the sheet is this:
"Use this type of bolt" Bolt=0.25in
Is that what you're saying?? because i found that i can put the variable inside of the text, but still the word Bolt will still appear, like this:
"Use Bolt=0.25in diameter"
The thing is that i don't want the word Bolt to show, i just want:
"Use 0.25in diameter"
Is there a way to do that?? if not is ok, no problem.
==========================================================
Now i have a 3rd question:
In Excel i can use the command CHOOSE to choose a value from a list or something. Now i try searching in the help and every where for the CHOOSE command but i didn't found anything. This command exists in MathCAD?
RE: Excel comands on MathCAD
Q3. That's because CHOOSE is the poor man's solution to not having indexed variables, which is directly supported in Mathcad:
i:0;10
x[i:blah_i
TTFN
RE: Excel comands on MathCAD
RE: Excel comands on MathCAD
TTFN
RE: Excel comands on MathCAD
1- Start with the variable :
Bolt:=0.25in
2- Define the following strings:
a:="Use Bolt = " include space within the quote
- Convert the number Bolt to strin:
b:=num2str(Bolt/1in)
Notice (Bolt/in)= number without unit.
c:= "in diameter"
3- Link together the 3 strins:
X:=concat(a,b,c)
Result:
X="Use Bolt=0.25in diameter"
NOTE: If portion of this need to be hidden for presentation purposes go to [insert] menu then [Area] and move the variable and text within the mark. Finally, double click to hide the desire area.
RE: Excel comands on MathCAD
Ok, THAT'S WHAT I WAS TRYING TO SAY!!, is exactly what it is!!, THANK YOU VERY MUCH!!!, i just try it and perfect!!
To IRstuff:
This part:
i:0;10
x[i:blah_i
I don't understand that.
For now, thank you everybody to take tha time to do this, everything has been very helpfull.
RE: Excel comands on MathCAD
TTFN
RE: Excel comands on MathCAD
Hi, ok i try to put this:
i:0;10
x[i:blah_i
As it is on the sheet and doesn't work, because every time i try to put ":" puts me ":=", can you please do it on a sheet and the put a picture here, if is not to much, thanks!
RE: Excel comands on MathCAD