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("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