Skip to content
xlsoffice. All Rights Reserved
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Lookup and Reference Examples

  • How to get relative column numbers in a range in Excel
  • Convert text string to valid reference in Excel using Indirect function
  • How to get last column number in range in Excel
  • INDEX function: Description, Usage, Syntax, Examples and Explanation
  • How to use Excel FORMULATEXT function

Data Analysis Examples

  • How to Use Solver Tool in Excel
  • How to calculate correlation coefficient Correlation in Excel
  • How To Create Pareto Chart in Excel
  • Conditional Formatting Data bars Examples in Excel
  • How To Create Frequency Distribution in Excel

Data Validation Examples

  • Excel Data validation must not contain
  • Excel Data validation allow uppercase only
  • Excel Data validation don’t exceed total
  • Excel Data validation only dates between
  • Excel Data validation number multiple 100

Tag: ISFORMULA function

ISFORMULA function: Description, Usage, Syntax, Examples and Explanation

by

What is ISFORMULA function in Excel? ISFORMULA function is one of the Information functions in Microsoft Excel that checks whether there is a reference to a cell that contains a formula, and returns TRUE or FALSE. Syntax of ISFORMULA function ISFORMULA(reference) The ISFORMULA function syntax has the following arguments. Reference: Reference is a reference to the …

Continue Reading

Sum formulas only in Excel

by

This tutorial shows how to Sum formulas only in Excel using the example below; Formula =SUMPRODUCT(range*ISFORMULA(range)) Explanation To sum results from formulas only, you can use the SUMPRODUCT and ISFORMULA functions. In the example shown, the formula in F6 is: =SUMPRODUCT(sales*ISFORMULA(sales)) where “sales” is the named range C5:C13, values in C5:C9 are hardcoded, and values in C10:C13 …

Continue Reading

Learn Basic Excel

Ribbon
Workbook
Worksheets
Format Cells
Find & Select
Sort & Filter
Templates
Print
Share
Protect
Keyboard Shortcuts

Categories

  • Charts
  • Data Analysis
  • Data Validation
  • Excel Functions
    • Cube Functions
    • Database Functions
    • Date and Time Functions
    • Engineering Functions
    • Financial Functions
    • Information Functions
    • Logical Functions
    • Lookup and Reference Functions
    • Math and Trig Functions
    • Statistical Functions
    • Text Functions
    • Web Functions
  • Excel VBA
  • Excel Video Tutorials
  • Formatting
  • Grouping
  • Others
  • Add line break based on OS in Excel
  • Remove unwanted characters in Excel
  • How to extract substring in Excel
  • How to remove trailing slash from url in Excel
  • How to strip non-numeric characters in Excel
  • How to calculate next anniversary date or birthday in Excel
  • HOUR function: Description, Usage, Syntax, Examples and Explanation
  • How to calculate Next working/business day in Excel
  • Add decimal minutes to time in Excel
  • How to show last updated date stamp in Excel
  • DISC function: Description, Usage, Syntax, Examples and Explanation
  • PRICEDISC function: Description, Usage, Syntax, Examples and Explanation
  • RATE function: Description, Usage, Syntax, Examples and Explanation
  • PRICE function: Description, Usage, Syntax, Examples and Explanation
  • NPER function: Description, Usage, Syntax, Examples and Explanation
Acronyms, Abbreviations, Initialism & What They Stand For
© 2021 xlsoffice. All Rights Reserved | Teal Smiles