If you are looking for a **vector formula in Excel**, you have come to the right place. Here, we will walk you through **5 **easy examples of doing the task effortlessly.

**Download Practice Workbook**

You can download the Excel file and practice while reading this article.

## What Is Vector Quantity?

A quantity with both direction and magnitude is called a **Vector** quantity. For instance, ** Force**,

**,**

*Acceleration***, etc. are**

*Displacement***Vector**quantities. Vectors of the same type and dimension can be added or subtracted. A column vector and a row vector with the same dimension can be multiplied.

## 5 Suitable Examples to Apply Vector Formula in Excel

In the following dataset, you can see** Data A** and **Data B**. Both these data are vector data. Using this dataset, we will describe** 5** easy and effective examples of using **vector formulas in Excel.** Here, we use **Excel 365**. You can use any available Excel version.

### 1. Addition Formula to Sum up Two Vector Data

In this method, we will **add **vector data using a vector formula in Excel, and we will find the vector sum.

**Steps:**

- First, we will type the following formula in cell
**D5**.

`=B5:B10+C5:C10`

- At this point, since this is an
**array formula**press**CTRL+SHIFT+ENTER**if you do not have**Excel 365**. - However, if you are using
**Excel 365**, press**ENTER**. - Therefore, you can see the result in cells
**D5:D10**.

**Read More:** **Plotting Vectors in Excel (with Easy Steps)**

### 2. Subtraction Formula to Deduct One Vector Data from Another One

In this method, we will **subtract** vectors using a vector formula in Excel.

**Steps:**

- In the beginning, we will type the following formula in cell
**D5**.

`=B5:B10-C5:C10`

- Afterward, since this is an array formula press
**CTRL+SHIFT ENTER**if you do not have**Excel 365**. - However, if you are using
**Excel 365**, press**ENTER**. - Therefore, you can see the result in cells
**D5:D10**.

### 3. Vector Dot Formula for Two Sets of Vector Data

In this method, we will use the vector dot formula to find the multiplication of vectors.

#### 3.1. Generic Formula

Here, we will use the** A.B** formula to find the multiplication of vectors.

**Steps:**

- First of all, we will type the following formula in cell
**D5**.

`=C5*B5`

- After that, press
**ENTER**. - Therefore, you can see the result in cell
**D5**. - Furthermore, we will drag down the formula with the
**Fill Handle tool**.

- Therefore, you can see the complete
**A.B**column.

- Moreover, we will find out the som of this multiplication.
- To do so, we will type the following formula in cell
**D11**.

`=SUM(D5:D10)`

- Here,
**the SUM function**sums up a range of cells.

- Afterward, press
**ENTER**. - Hence, you can see the result in cell
**D11**.

#### 3.2. Applying SUM Function

In this method, we will use **the SUM function **for the vector formula in Excel to find out the multiplication of a range of cells.

**Steps:**

- To do so, in the first place, we will type the following formula in cell
**C12**.

`=SUM(B5:B10*C5:C10)`

- After that, since this is an array formula press
**CTRL+SHIFT+ENTER**if you do not have**Excel 365**. - However, if you are using
**Excel 365**, press**ENTER**. - Therefore, you can see the result in cells
**C5:C10**.

#### 3.3. Combining MMULT and TRANSPOSE Functions

In this method, we will use the combination of the **MMULT** and **TRANSPOSE** functions in the vector formula to find the multiplication of vectors.

**Steps:**

- In the beginning, we will type the following formula in cell
**C12**.

`=MMULT(TRANSPOSE(B5:B10),(C5:C10))`

**Formula Breakdown**

**The MMULT function**gives out the matrix product of two ranges of cells.**The TRANSPOSE function**modifies the orientation of a range of cells.**TRANSPOSE(B5:B10)â†’**becomes**Output: {3,5,7,9,11,13}**

**MMULT(TRANSPOSE(B5:B10),(C5:C10)****â†’**becomes**MMULT({3,5,7,9,11,13}),(C5:C10))Â****Output:Â 592**

- After that, press
**ENTER**. - Therefore, you can see the result in cell
**C12**.

**Read More: How to Calculate Vector Multiplication in Excel (2 Useful Examples)**

### 4. Vector Cross Formula for Two Sets of Vector Data

In this method, we will use the **vector cross formula**Â to find the multiplication of two vectors.

In the following dataset, you can see we have the value of **IaI **(value of the first vector), **IbI **(value of the second vector), and the angle between them **Î¸** in degree.

Moreover, we have to convert the angle to **Radians**.

Furthermore, we will find the cross multiplication by using the formula **a x b=IaI IbI SinÎ¸**

**Steps:**

- In the beginning, to convert the
**Degree**in**Radians**, we will type the following formula in cell**C8**.

`=RADIANS(C7)`

- Here,
**the RADIANS function**converts the**degree**into**radians**.

- In addition, press
**ENTER**. - Therefore, you can see the result in cell
**C8**.

** **

- Moreover, to find out the
**SinÎ¸**, we will type the following formula in cell**C9**.

`=SIN(C8)`

**The SIN function**converts the**Radian**angle into the**sin**angle.

- After that
**,**press**ENTER**. - As a result, you can see the result in cell
**C9**.

- Now, it is time to find out the
.*cross-product* - Therefore, we type the following formula in cell
**C10**.

`=C5*C6*C9`

- At the moment, press
**ENTER**. - As a result, you can see the output in cell
**C10**.

### 5. Vector Formula to Find Two Components Using Magnitude and Reference Angle of This Vector

Here, in the following picture, you can see a figure where the magnitude of a vector is **10**, and the direction is **60Â°**. Furthermore, we will find **X** and** Y** of the figure.

We know, **X = 10 CosÎ¸**And

**Y=10 SinÎ¸**

Here, we have inserted the data of the figure in the dataset. Then, we will find out

**X**and

**Y**.

**Steps:**

- In the beginning, to convert the
**Degree**in**Radians**, we will type the following formula in cell**C7**.

`=RADIANS(C6)`

- Here,
**the RADIANS function**converts the degree into radians.

- In addition, press
**ENTER**. - Therefore, you can see the result in cell
**C8**.

- Next, to find the
**X**, we will type the following formula in cell**C8**.

`=C5*COS(C7)`

- Afterward, press
**ENTER**. - Therefore, you can see the result in cell
**C8**.

- Moreover, to find the
**Y**, we will type the following formula in cell**C9**.

`=C5*SIN(C7)`

- As a result, you can see the outcome in cell
**C9**. - Hence, we can use a vector formula to find out
**X**and**Y**.

## Practice Section

You can download the following Excel file and practice the explained methods.

**Conclusion**

Here, we show you** 5 **easy examples to use **vector formula in Excel**. Thank you for reading this article. We hope it was helpful. If you have any queries, please let us know in the comment section. You can visit our website** Exceldemy** for more related articles.