Toronto-based ShawCor's Socotherm pipe coating division has become the latest entrant in the region's pipeline coatings market after it was awarded a $40 million contract by Tenaris to provide pipeline coatings for the Republic of Congo's.
The Microsoft Excel IF function returns one value if the condition is TRUE, or another value if the condition is FALSE. The IF function is a built-in function in Excel that is categorized as a Logical Function. It can be used as a worksheet function (WS) in Excel. As a worksheet function, the IF function can be entered as part of a formula in a cell of a worksheet.
The value arguments of the IS functions are not converted. For example, in most other functions where a number is required, the text value 19 is converted to the number 19. However, in the formula ISNUMBER(19), 19 is not converted from a text value, and the IsNumber(Object) function returns false. The IS functions are useful in formulas for testing the outcome of a calculation. When combined with the IF function, they provide a method for locating errors in formulas.