Forum Discussion
IF statement more than 64; Macro?
Hello thanks for taking a moment to try to help me. I am working on a spreadsheets that I am hoping to simplify. What I am looking for is a function that will read a cell and then imput a v...
If the number of nested IFs goes beyond 4, there is probably something wrong with your approach! The best approach is likely to be a lookup. For example
= XLOOKUP(county, feeTbl[County], feeTbl[Fee])
