MATCHCASE returns the case number of the value(s) ithat that best match the arguments given in the function
...
A = MATCHCASE(1,3,"XC","YC","ZC",2,6,13,1)
With in the Dataslot:
|MATCHCASE1|
0
3 "XC" "YC" "ZC"
"1" 1 9 10
"2" 2 8 11
"3" 3 7 12
"4" 4 6 13
"5" 5 5 14
"6" 6 4 15|
Results in: A=3. This means that case three has the smallest Euclidian distance with the dataset: 2,6,13.
Quick links: Functions overview | Attribute overview | Constants overview | Dimensions overview
replacementstringdezemoetuniekzijnbladibla