How long / many nested "IF(AND" can be done?

1 Reply



If I could answer your question first with another question: What exactly are you trying to accomplish here? When there are two conditions to be met, it often is actually more effective (and makes for a formula easier to understand and maintain) to use INDEX in connection with dual MATCH functions, the latter specifying the conditions, the former providing the resolution.


See the attached file for a very simple example created for a different person. There is a single formula in cell C14 that pulls results from the table at the top of the screen based on two conditions. There here are only 20 possible combinations of conditions, but that number could be many  multiples of 20. And as you can see, there is no need to write IF(AND( for each of the 20 conditions.