1 Pages (7 items)
Drop down options - Select variable based on the value of another variable - Messages
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
Thanks Jean
I will try this one
I will try this one
Look within!... The secret is inside you.
Best Regards
Eng. NDTM Amarasekera - Sri Lanka
1 users liked this post
Davide Carpi 2020/5/1 08:59:00
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 2020/5/1 08:59:00
Generalize demo. No sweat to capture [X,Y,Z] from n*m matrix.
Page5 Generalize.sm (5.88 KiB) downloaded 650 time(s).
Page5 Generalize.sm (5.88 KiB) downloaded 650 time(s).
1 Pages (7 items)
- New Posts
- No New Posts
