Choosing between IFS and SWITCH functions in Excel | Everyday Office скачать в хорошем качестве

Choosing between IFS and SWITCH functions in Excel | Everyday Office

For one criteria at a time, the IF function does the job. However, any time your logic gets a little more complicated, you can use IFS or SWITCH. IFS is best for making varied decisions across the dataset, while SWITCH assumes you're always judging the same value for multiple directions. Everyday Office is the media arm of Knack Training, a software and professional development training and consulting company headquartered in Orlando, FL. More content can be found on: http://www.knacktraining.com/blog/ http://www.knacktraining.com/podcast/ Check the playlists on the Everyday Office channel for more tutorials in the areas you are having the most trouble with.