IFNA Function
The IFNA function is a nice way to capture and manage #N/A errors without capturing other errors. The IFNA function can be used to capture
IFERROR Function
One of the most useful functions within Excel is the IFERROR function, which can prove to be a game-changer for your data manipulation and analysis
FALSE Function
The FALSE function returns the Boolean value False. This function is knowns as a “compatibility function”, used only for compatibility with other functions. For example,
AND Function
The AND function of Excel is used to compare more than one logical condition. Up to 255 conditions can be compared at a time, which
IF Function
Excel’s IF function runs a logical comparison and outputs a result as either TRUE or FALSE. For the example below, students who have secured a
Getting Started with Excel
Excel is the most used spreadsheet program (sharing from experience!) for storing, organizing, analyzing, and sharing information. Follow this easy tutorial for Getting Started with Excel.
