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.
For example, by nesting the AVERAGE and SUM function in the arguments of the IF function, the following formula sums a set of numbers (G2:G5) only if the average of another set of numbers (F2:F5) is greater than 50. Otherwise, it returns 0. 1. The AVERAGE and SUM functions are nested within the IF function. You can nest up to 64 levels of functions in a formula. Click the cell in which you want to enter the formula. To start the formula with the function, click Insert Function on the formula bar . Excel inserts the equal sign (=) for you.