Excel Office

Excel How Tos, Tutorials, Tips & Tricks, Shortcuts

Tag: ISFORMULA function

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

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 cell you want to test.…

Sum formulas only in Excel

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 are generated with formulas. How…