Happily, there are alternatives which return the same result but are a lot easier to understand, change and fix when they go wrong. ![]() Those long formulas can be very hard to understand (especially if you’re new to the worksheet) and debug (one missing or extra comma is enough). This example has only five levels of nesting, we’ve seen nested IF’s with many, many more than that. ![]() We’ll start with the relatively simple example we used for demonstrating IF and nested IF. ![]() Nested IF statements can be hard to understand and manage but there are alternatives which can be easier to handle, fix and change. ![]() Thanks for joining us! You'll get a welcome message in a few moments.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |