![]() A simple nested IF with 2 or 3 options can grow with more and more IFs to the point where it’s unreadable and prone to coding error. It usually creeps up on everyone over time. ![]() No-one ever sets out to make a long group of nested IFs. In a simple example like this a nested IF is enough however there are other options that are easier to read by other people. In Excel there are all manner of ways to do this. The rating number in column B is turned into a text description in Column C.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |