Excel Formulas: IF Function with Other Calculations!!
Tags: excelformula, excelformulas
Published: 2021-02-25 11:32:18

---
title: Excel Formulas: IF Function with Other Calculations!!
published: true
date: 2021-02-25 11:30:11 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/excel-formulas-if-function-with-other-calculations/
---

The Excel IF function is helpful if you want to check something on a worksheet, then show results A or B. In this tutorial, we are going to look at **how to find the value with other calculations in Excel by using the IF function**. Let’s get into this article!! Get an official version of ** MS Excel**  from the following link: [https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)

[![If with other calculations](https://geekexcel.com/wp-content/uploads/2021/02/If-with-other-calculations.png)](https://geekexcel.com/excel-formulas-if-function-with-other-calculations/if-with-other-calculations/#main)<figcaption id="caption-attachment-22144">If with other calculations</figcaption>

## Generic Formula:

- Use the below formula to find the value with multiple calculations.

**=[IF](https://geekexcel.com/use-if-function-in-microsoft-excel-365-simple-steps/)(calculation1,calculation2,calculation3)**

## Syntax Explanations:

- **IF** – In Excel, the **[IF function](https://geekexcel.com/use-if-function-in-microsoft-excel-365-simple-steps/)** helps to return one value for a **[TRUE](https://geekexcel.com/use-true-function-in-microsoft-excel-365-simple-methods/)** result, and another for a **[FALSE](https://geekexcel.com/use-false-function-in-microsoft-excel-365-simple-methods/)** result.
- **SUM** – It is used to add the cell values. Read more on the **[SUM function](https://geekexcel.com/sum-function/)**.
- **Comma symbol (,)** – It is a separator that helps to separate a list of values.
- **Parenthesis ()** – The main purpose of this symbol is to group the elements.

## Practical Example:

Refer to the below example image.

- Here, we will enter the input table 1 in **Column B** and **Column C** , then enter another input table 2 in **Column D** and **Column E**.

![Input Ranges](https://geekexcel.com/wp-content/uploads/2021/02/Input-Ranges-24.png)<figcaption id="caption-attachment-22145">Input Ranges</figcaption>

- Now we are going to sum the values in table 1 based on table 2 calculations.
- So, apply the above-given formula to the [**formula bar**](https://geekexcel.com/how-to-use-formula-bar-for-various-purpose-in-excel-365/) section and press the **“Enter”** key.

![Enter the formula](https://geekexcel.com/wp-content/uploads/2021/02/Enter-the-formula-26.png)<figcaption id="caption-attachment-22146">Enter the formula</figcaption>

- Finally, we will get the result in the selected cell.

![Result](https://geekexcel.com/wp-content/uploads/2021/02/Result-29.png)<figcaption id="caption-attachment-22147">Result</figcaption>

## Closure:

Hope you like this article on how to find the value based on other calculations in Excel by using the If function? Don’t forget to share your worthwhile feedback about this article. Thank you so much for visiting our site!! Click here to know more about **[Geek Excel](https://geekexcel.com/) **and [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!! **

### Read Also:

- **[Excel Formulas: Exact Match Lookup With SUMPRODUCT!!](https://geekexcel.com/excel-formulas-exact-match-lookup-with-sumproduct/)**
- **[Formula to Count Number of Weekends/Weekdays/Specific Day of Week!!](https://geekexcel.com/formula-to-count-number-of-weekends-weekdays-specific-day-of-week/)**