Nested IF statements used to be my go-to whenever I needed to juggle multiple conditions in Excel. However, just because they get the job done doesn’t mean they’re the best tool for the job. Wrestling with endless parentheses and trying to keep track of which IF controls which outcome feels about as tedious as just checking the numbers yourself. And if you try revisiting the formula a week later, good luck remembering why you set it up that way.
via MakeUseOf https://ift.tt/dJLPzBn
Comments
Post a Comment