Drop down options - Select variable based on the value of another variable - Mensajes
#1 Publicado: 30/4/2020 5:32:46
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 Publicado: 30/4/2020 8:33:57
![p[XYZ].PNG](/es-ES/files/Download/vyGwDS/p[XYZ].PNG)
#3 Publicado: 30/4/2020 8:36:30
Thanks Jean
I will try this one
I will try this one
#4 Publicado: 30/4/2020 8:42:33
Look within!... The secret is inside you.
Best Regards
Eng. NDTM Amarasekera - Sri Lanka
A 1 usuarios les gustó este mensaje
Davide Carpi 1/5/2020 8:59:00
#6 Publicado: 30/4/2020 11:25:14
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
A 1 usuarios les gustó este mensaje
Davide Carpi 1/5/2020 8:59:00
#7 Publicado: 30/4/2020 12:41:19
- Nuevos mensajes
- Sin mensajes nuevos