How Functions WorkAdding Functions with the Functions TabUsing Cell Ranges in FunctionsAdding Cell Ranges to FormulasCommon Math FunctionsQuick-Formula Functions and Basic MathSUM: Adding NumbersCOUNT, COUNTA, and COUNTBLANK: How Many?MAX and MIN: Finding the Biggest and SmallestLARGE, SMALL, and RANK: Ranking ValuesAVERAGE and Median: Finding the Middle ValueMultiplying with PRODUCTQUOTIENT and MOD: Divide and ConquerRounding NumbersSimple Rounding with ROUND, ROUNDDOWN, and ROUNDUPLopping off Decimal Digits with INT and TRUNCMROUND, CEILING, and FLOORTransforming Text in FormulasWorking with Portions of StringsLEFT, MID, and RIGHT: Extracting TextLEN, FIND, and SEARCH: Counting CharactersSUBSTITUTE: Replacing TextCleaning Up TextFormatting Numbers in TextWorking with Dates and TimesDoing Math with Dates and TimesAdding or Subtracting Durations from a Date ValueWORKDAY: Leave Your Weekends Out of itSubtracting One Date Value from AnotherUsing Math Functions with Date ValuesBuilding Dates and Times in FormulasExtracting Date and Time InfoWhat IF: Adding Logic to FormulasSetting Conditions with the IF FunctionUsing Comparison OperatorsTesting Multiple Conditions with AND and OROther Condition FunctionsNesting IF Functions to Give Multiple InstructionsSmart Summaries: COUNTIF, SUMIF, and AVERAGEIFAdding and Averaging a Row or Column Based on Values of AnotherAdding More Conditions: COUNTIFS, SUMIFS, and AVERAGEIFSPulling it All Together: Using if Math to Summarize DataLooking Up and Fetching Cell DataUsing VLOOKUP and HLOOKUPMatching Text with VLOOKUP and HLOOKUPManaging “Left Lookups”Using LOOKUP for Easier (but Inexact) MatchesDoing Close-Match LookupsUsing MATCH and INDEX to Fetch ValuesOther Lookup Functions