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.
Tag: Operator Precedence
Simple Excel Formulas and Functions
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. For example, cell A3 below…