This article shows you how to use the conjugate and intersect operators (the outline below is for illustration only) in Excel.
Join the channel Telegram of the AnonyViet 👉 Link 👈 |
Conjugate and intersect in Excel
1. The conjugate operator (comma) adds two ranges.
Explanation: SUM function to =SUM(C4:D8) + SUM(D7:E11).
2. The intersection operator (single space) returns the intersection of two ranges.
3. Excel automatically adds the conjugate operator (comma). For example, type =SUM( and hold CTRL to select the ranges below.
4. You can use the intersection operator (space) to return the intersection of two zone names.
In addition, you can also view many other excel articles here.