Forum Discussion
If function
Hi, I want to make an IF function that the data is inputted from 3 different columns. Column A is a combo box of text data. Column B is a numeral numbers that has 3 different ranges. Column C is a...
Thank you.
As always, there are so many options in Excel. FYI - In some cases I prefer nested IF() instead of IFS(). There are some discussions about the benefits of each but basically if you are not using dynamic arrays and have complicated formulas that you do NOT want to get calculated then nested IF can be better. So for example
IF( simple case is true, "answer A", IF( complicated computationally taxing case,, "answer B", "answer C"))
is better than using IFS because IFS calculates all parts regardless while IF will not (as long as you don't put dynamic arrays inside).
IF( simple case is true, "answer A", IF( complicated computationally taxing case,, "answer B", "answer C"))
is better than using IFS because IFS calculates all parts regardless while IF will not (as long as you don't put dynamic arrays inside).