Open links in new tab

Got it, one moment

...
Feedback
AI generated code. Review and use carefully. More info on FAQ.
  1. Copilot Answer
    Exceljet
    https://exceljet.net › formulas › if-with-other-calculations

    IF with other calculations - Excel formula | Exceljet

    • The IF functionevaluates a logical test and returns one value if the result is TRUE, and a different value if the result is FALSE. The generic syntax for IF looks like this: For example, if cell A1 contains th… See more

    Example

    In the worksheet shown, the goal is to apply a simple quantity-based discount to the total calculated in column E. If the quantity is greater than 20, we want to discount the total by 10… See more

    Exceljet
    Excel IF Formula: Simple to Advanced (multiple criteria, nested IF, AND, OR functions)
    15:23
    Excel IF Formula: Simple to Advanced (multiple criteria, nested IF, AND, OR functions)
    YouTubeLeila Gharani3.8M viewsFeb 1, 2018
  1. Microsoft Support
    https://support.microsoft.com › en-us › office › using...

    Using IF with AND, OR, and NOT functions in Excel

    How to use the IF function (combined with the AND, OR, and NOT functions) in Excel to make logical comparisons between given values.

  2. Microsoft Support
    https://support.microsoft.com › en-us › office

    IF function - Microsoft Support

    The IF function is one of the most popular functions in Excel, and it allows you to make logical comparisons between a value and what you expect. So an IF statement can have two results. …

  3. ExcelDemy
    https://www.exceldemy.com › excel-if-function

    How to Use IF Function in Excel (8 Suitable Examples)

      1. IF Function to Show Statements Based on Logical Test. In our dataset, there are two …
      2. Using IF Function to Return Calculated Result. Now we’ll use the IF function to find bonuses …
      3. Use of Nested IF Function in Excel. The nested IF formula is widely used to determine the …
      4. IF with AND, OR and NOT Functions. Let’s get introduced to another new dataset now that …
      5. IF with ISBLANK, ISTEXT, ISNUMBER and ISLOGICAL Functions. In Microsoft Excel, …
      See full list on exceldemy.com
  4. Spreadsheeto
    https://spreadsheeto.com › if-then-formula-excel

    How to Write an IF Then Formula in Excel (Examples)

    Aug 29, 2024 · Step 1) Write the IF-then statement by writing the IF function as follows: Step 2) As the logical test, specify the condition to check if the scored marks of each student are more than 50. Step 3) Specify the value_if_true that …

  5. Excel Easy
    https://www.excel-easy.com › examples › if.html

    IF function in Excel - Step by Step Tutorial - Excel Easy

    The IF function checks whether a condition is met, and returns one value if true and another value if false. 1a. For example, take a look at the IF function in cell B2 below. Explanation: if the price is greater than 500, the IF function returns …

  6. Five Minute Lessons
    https://fiveminutelessons.com › learn-microsoft...

    How to use the IF function in Excel to calculate values based on ...

    The IF function works by performing a logical test that can only have one of two outcomes - TRUE or FALSE. It then outputs a result based on the outcome of that test. Logical Tests in Excel. …

  7. Ablebits
    https://www.ablebits.com › ... › if-function-excel

    IF function in Excel: formula examples for text, numbers …

    May 23, 2023 · In this article, you will learn how to build an Excel IF statement for different types of values as well as how to create multiple IF statements. IF is one of the most popular and useful functions in Excel.

  8. tpointtech.com
    https://www.tpointtech.com › excel-if-function-with...

    Excel If Function with Calculations - Tpoint Tech

    Mar 17, 2025 · "IF function" can be used in complex calculations. See the example: If a sales executive sells more than 5 items, the company will pay incentive 40 rupees per item sold and if the sales executive sells less than 5 …

  9. Ablebits
    https://www.ablebits.com › office-addins-blog › excel...

    Excel IF function with multiple conditions - Ablebits

    Mar 22, 2023 · In essence, there are two types of the IF formula with multiple criteria based on the AND / OR logic. Consequently, in the logical test of your IF formula, you should use one of these functions: AND function - returns TRUE …

  11. Some results have been removed
Refresh