May 12, 2016 | String functions, Write a Formula

Introduction What are Excel string functions? Excel string functions allow handling and manipulating text strings: combining text from different cells in one string, extracting parts of the string based on their position or surrounding symbols, substituting parts of...
May 9, 2016 | Logical functions, Write a Formula

Introduction What are logical functions in Excel? Logical functions in Excel help perform a diverse set of logical operations, from setting most basic conditions and linking them with different outcomes to performing complicated scenario analysis. Logical functions...
May 3, 2016 | Write a Formula

Introduction What is an Excel formula? Excel formulas are expressions that define how the value of an Excel cell is calculated. The value of the cell is automatically updated every time when the cells that are referenced in its formula change their values. Excel...
Jan 10, 2016 | Write a Formula

Introduction What is Excel ISNA function? ISNA is one of the so-called IS-functions in Excel. It checks whether a cell contains a #N/A error, which Excel returns when the value is not available to the formula for some reason. Why do we need ISNA? The primary rationale...
Jan 9, 2016 | String functions, Write a Formula

Introduction What is Excel TEXT function? Excel TEXT function is designed to convert any non-text values on the worksheet – e.g., numbers, dates, currencies, percentages – to a text format specified by the user. Why do you need TEXT function? TEXT function is widely...