Forum Discussion

Fredrik123's avatar
Fredrik123
Copper Contributor
Dec 11, 2018

Formula

Hi.

Is there a way to write 2 formulas into 2 cells. Then have a cell use the one more usefull of those 2? 

excel
Formulas and Functions

3 Replies

    • Fredrik123's avatar
      Fredrik123
      Copper Contributor
      Dec 12, 2018
      By usefull I mean the one that works. So if I have 2 kind of filter formulas, adn one of them doesn't work, then the other will step in.

      Or if I have a list I need filled in, but I need many different formulas to fill quickly. I just want one that can choose from different premade formulas, so it chooses the first who works
      • erol sinan zorlu's avatar
        erol sinan zorlu
        Iron Contributor
        Dec 12, 2018

        For calculating a value with different conditions Excel has IF formula.

         

        If one of the formulas returns an error, like dividing to zero, there is IFERROR formula that checks if the result is an error and use another formula for calculation if this is the case.

         

        However these formula will show the result of different formulas in the same cell. If you want to show the result of the two formulas at the same time you need to write these formulas to different cells. And if one of them returns error check it with IFERROR function and display the result of the other formula in a different cell.

         

        If you want to create different formulas depending on user selection, I do not think this is possible with Excel built in funcitons. However you can create a VBA with a user form to do this.