Tag: Operator Precedence

How to use Union and Intersect operators in Excel

by

This example illustrates how to use the union and intersect operator (borders below for illustration only) in Excel. 1. The union operator (comma) adds two ranges. Explanation: the SUM function reduces to =SUM(C4:D8) + SUM(D7:E11), 20. 2. The intersect operator (single space) returns the intersection of two ranges. Explanation: the SUM function reduces to =SUM(D7:D8), 2.

Continue Reading

Simple Excel Formulas and Functions

by

Every formula in Excel starts with an equal sign, function name then in bracket a cell name or cell ranges or cell references. See illustration below: =Function Name( cell name or cell ranges or cell references) Example: = SUM(A1:A4) A formula is an expression which calculates the value of a cell. Functions are predefined formulas and are already available in Excel. …

Continue Reading