Don’t bother with IF in Excel when you can use this function instead

Don’t bother with IF in Excel when you can use this function instead
https://www.makeuseof.com/dont-bother-if-in-excel-when-you-use-this-function/

  • SWITCH is the function you should have been using
    It does the same job as nested IF, but without the chaos
  • SWITCH handles real-world scenarios better than IF
    Here’s what that looks like with actual data
  • There are a few things SWITCH can’t do
    When your conditions involve ranges, IFS is the smarter call
  • Make the switch from IF in your existing spreadsheets
    You don’t have to rewrite everything at once
  • There’s more where this came from
    SWITCH and IFS are good, but they work even better with these functions

Zie ook: