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.
What we really need is way to make our spreadsheet do this automatically. While you might never have used it before, the IF function can simplify these kinds of problems. The IF function can look at a value in a cell to see if it meets a basic condition (in our example, if the value is greater than or equal to 50).