티스토리 뷰
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("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.
반응형
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 |