1 Pages (7 items)
Drop down options - Select variable based on the value of another variable - Messages
#1 Posted: 5 years ago
Hi I am new to Smath
I want to select few variables. eg
If P=1, then X = 1, Y=2 & Z=3
If P=2, then X = 4, Y=1 & Z=7
If P=3, then X = 3, Y=2 & Z=1
I want to use X, Y & Z values based on the selected value of P
Thanks in advance
I want to select few variables. eg
If P=1, then X = 1, Y=2 & Z=3
If P=2, then X = 4, Y=1 & Z=7
If P=3, then X = 3, Y=2 & Z=1
I want to use X, Y & Z values based on the selected value of P
Thanks in advance
#2 Posted: 5 years ago
#3 Posted: 5 years ago
Thanks Jean
I will try this one
I will try this one
#4 Posted: 5 years ago
Look within!... The secret is inside you.
Best Regards
Eng. NDTM Amarasekera - Sri Lanka
1 users liked this post
Davide Carpi 5 years ago
#6 Posted: 5 years ago
If you want to use the variable names X,Y,Z
a simple
data:mat(1,4,3,2,1,2,3,7,1,3,3)
mat(X,Y,Z,3,1):col(data,p)
will do the job.
you can also use a vector XYZ
XYZ:el(data,range(1,3),p)
and its components i=1..3
el(XYZ,i)
--
copy code to sheet
a simple
data:mat(1,4,3,2,1,2,3,7,1,3,3)
mat(X,Y,Z,3,1):col(data,p)
will do the job.
you can also use a vector XYZ
XYZ:el(data,range(1,3),p)
and its components i=1..3
el(XYZ,i)
--
copy code to sheet
1 users liked this post
Davide Carpi 5 years ago
#7 Posted: 5 years ago
Generalize demo. No sweat to capture [X,Y,Z] from n*m matrix.
Page5 Generalize.sm (5 KiB) downloaded 102 time(s).
Page5 Generalize.sm (5 KiB) downloaded 102 time(s).
1 Pages (7 items)
-
New Posts
-
No New Posts