Survey Software Development - Logica Scientific Functions



The ‘IF’ function allows you to check if a certain condition in a worksheet is true or false, and gives out results accordingly. The syntax for the IF function is: =IF(logical_test,value_if_true,value_if_false) logical_test – It is a value or expression that is tested to see if it is true or false. value_if_true - It is the value that is displayed if logical_test is true. value_if_false - It is the value that is displayed if logical_test is false. For example, if you want to select the X Coordinates below 1000 from column C, then you can use the ‘if’ function and mark these cells by 0 or 1. The formula to be used here is [=IF(C3<1000,1,0)] You can then filter the resulting column and extract the data as per your requirement.

8_1.png

SIN: The SIN function is one of the many trigonometry functions in excel. It allows you to find the sine of an angle measured in radians. The syntax for the SIN function is: = SIN(Number) Where in, Number is the angle in radians being calculated.

154.png

COS: The COS function is one of the many trigonometry functions in excel. It allows you to find the cosine of an angle measured in radians. The syntax for the COS function is: = COS(Number) Where in, Number is the angle in radians being calculated.

TAN: The TAN function is one of the many trigonometry functions in excel. It allows you to find the tangent of an angle measured in radians. The syntax for the TAN function is: = TAN(Number) Where in, Number is the angle in radians being calculated

15.png