Chris Benoit, a professional wrestler known as the Canadian Crippler, killed his wife and 7-year-old son in their house in Fayetteville, Ga., over the weekend before taking his own life by hanging himself with a cable from a weight machine in his home gym, investigators said Tuesday. The authorities found the bodies on Monday afternoon as they were checking on the family at the request of Mr. Benoit's employer, World Wrestling Entertainment, said Lt. Tommy Pope, lead investigator ...
The Excel IFNA Function. Basic Description. The Excel IFNA function tests if an initial supplied value (or expression) evaluates to the Excel #N/A error. If so, the function returns a second supplied value; Otherwise the function returns the first supplied value. Note: the IFNA function is new to Excel 2013, so is not available in earlier versions of Excel. value. The value or expression to be tested. value_if_na. The alternative value or expression, that is to be returned if the first supplied value evaluates to the #N/A error.
In other words, you will essentially use Ifâ¦then logic statements to build powerful processes that solve your real-life business problems. If you would like to begin learning this and other advanced features of Excel, a good place to start is an advanced online course in Excel. In this guide, we will learn more about what the IF function does, how to use it, and how to get the most out of it by including it within larger formulas. Background on the IF function Like most of the functions you are familiar with in Excel, the IF function delivers an output to a single cell, as opposed to a range of cells (as would be the case for an array function). In using it to process multiple entries throughout a spreadsheet, you construct it for a single cell and then copy it down to additional cells in a range.