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.
Check Cell Value. As another example of the IF function, you can check the value in a cell, and show âGoodâ if the value is $20,000 or more. For lower amounts, the result is âPoorâ.You can use more than one IF function in a formula too. Instead of just Good or Poor, you can nest a second IF in the formula, to test for a lower amount â $10,000 â and rate those results as âAverageâ. The key to nested IF functions is to put the tests in order of difficulty.1  In this example, 20000 is the highest amount that weâre testing for, so that test comes first.nstead of just Good or Poor, you can nest a second IF in the formula, to test for a lower amount â $10,000 â and rate those results as âAverageâ. The key to nested IF functions is to put the tests in order of difficulty. 1  In this example, 20000 is the highest amount that weâre testing for, so that test comes first.