티스토리 뷰

SMath

findrows[SMath]

skyground21 2023. 3. 7. 08:43

findrows fuction
 
Learn about the findrows function in Smath, which has the same function as Excel's vlookup function.
 
First you need to install the specialfunctions plugin.
When the installation is complete, it will look like the following picture

 
Please refer to the following example.
If you input the size of the reinforcing bar, you want to find the cross-sectional area of the reinforcing bar.

Use findrows fuction

 

findrows

findrows("1:matrix", "2:expression", "3:number")

Retrieves all rows of the "1:matrix" where "2:expression" exists in column "3:number".

Rerurns 0 if no matches found.

bar size.sm
0.01MB

 
https://youtu.be/UUEfzs0ceBo

 

반응형
LIST

'SMath' 카테고리의 다른 글

Truss Joint Method_Matrix  (0) 2023.03.08
Findindex  (0) 2023.03.07
Multi-linear regression  (0) 2023.03.06
mathematical items 입력 단축키  (0) 2023.03.03
Linear regression  (0) 2023.03.03