This tutorial is everything on “**SharePoint calculated column multiplication**“. I will show you two scenarios for implementing multiplication in a SharePoint calculated column.

**Scenario:** I will create a SharePoint calculated column where an employee’s salary is multiplied by the Percent hike to know a certain amount that will be added to the** employee’s salary **after the **appraisal**.

**Scenario: **Here, I have to calculate the time difference between the **start date** and to **end date **and **multiply it by 24** to get the time difference in hours in the SharePoint calculated column using the** INT function**.

## Multiplication in a SharePoint calculated column

Let’s find out how to implement multiplication in SharePoint Online calculated column. To do that, follow the below steps.

- Open a SharePoint Online list and then click on
**+ Add column**then select**See all column types**-> Click on the**Next**button. - Inside the
**Create column tab**, enter the**Column name**then select**The type of information in this column is**. Then insert the formula under**Additional column settings**by selecting a column from Insert column and also select**The data type returned from this formula is**-> Click on the OK button as shown below.

The formula used in SharePoint calculated column is listed below.

`=[Salary]*([Percent Hike]/100)`

- The screenshot below shows the SharePoint Online calculated column output using multiplication.

This is how to implement multiplication in SharePoint Online calculated column.

## SharePoint Online calculated column multiplication using the INT function

In this section, I will explain how to implement the INT function for multiplication in SharePoint calculated column. To achieve it, follow the below steps.

- Go to the
**Create column**tab using the steps in the previous section and then enter the**Column name**, then select**The type of information in this column is**. - Now insert the formula in the formula box by selecting the column from the
**Insert column**then select**The data type returned from this formula is**and click on the OK button.

- Then you see the SharePoint calculated column multiplication output as shown below.

This is how multiplication in SharePoint Online calculated column is implemented.

## Conclusion

In this SharePoint tutorial, I have explained how to do **multiplication in a SharePoint Online calculated column**. Then I have shown you how two date column differences multiply by 24 to give the output as the number of hours using the INT function.

You may like the following tutorials:

- SharePoint calculated column equals another column
- Add leading zeros in SharePoint calculated column

Preeti Sahu is an expert in Power Apps and has more than 6 years of experience working with SharePoint and the Power Platform. As a Power Platform expert for Power BI, Power Apps, Power Automate, Power Virtual Agents, and Power Pages, she is currently employed with TSinfo Technologies. She is the author of the book **Microsoft Power Platform A Deep Dive.**Â She also made a big technical contribution to SharePointDotNet.com in the form of articles on the Power Platform. She enjoys traveling and spending time with her family in her spare time.