Forum Discussion
Formula
what do you mean by "usefull"?
- 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 worksFor 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.
