Forum Discussion

Deleted's avatar
Deleted
Nov 06, 2018

Example mathematical formula Excel

I have to write this formula in excel 365, if the value of cell A1 is> 10 and <20 shows the value contained in cell A2. What is the solution. Thank you

excel
    • Donato Gerardi's avatar
      Donato Gerardi
      Copper Contributor
      Nov 06, 2018

      to add the same formula for another cell?Example: = IF (AND (A1> 10; A1 <20); A2; "") (A3> 20; A3 <40); A5; "").
      thank you

       

      • erol sinan zorlu's avatar
        erol sinan zorlu
        Iron Contributor
        Nov 06, 2018

        First of all I am using the Turkish version of Excel so the ";" signs in the formula may need to be changed to ",". secondly if you mean using the same formula in a different cell with different control it can be. How ever if you want to check a second condition when the first one is not true you need to write nested ifs like

         

        =IF(AND(A1>10, A1<10);A2;IF(AND(A3>20, A3<40);A5;"")

         

        or if you have 2019 version you can use single command (not sure though)

         

        =IFS(AND(A1>10, A1<10),A2,(AND(A3>20, A3<40),A5)

Resources