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.
In this example, the formula will return 0 if cell A1 was either less than 150,000 or greater than 250,000. Otherwise, it will return the value in cell A1. Question: In Microsoft Excel, I'm trying to use the IF function to return 25 if cell A1 > 100 and cell B1 < 200. Otherwise, it should return 0. Answer: You can use the AND function to perform an AND condition in the IF function as follows: