In this #FormulaFriday video series, a new formula video will be released every Friday.
In this video you will learn how to use Switch( ) function in microsoft excel. When you have multiple condition we often use nested IF conditions. Using netsed #IF() is confusing and difficult to understand / read. Microsoft introduced new #switch() formula that is best used when you have nested IF conditions.
SUBSCRIBE HERE – https://www.youtube.com/channel/UCu1MwWuAWADFnziYMVtWWFw?sub_confirmation=1
👉 Follow on Twitter: https://twitter.com/esentialsoftech
👉 Follow on Instagram: https://www.instagram.com/esentialsoftech
SWITCH function :
The SWITCH function evaluates one value (called the expression) against a list of values, and returns the result corresponding to the first matching value. If there is no match, an optional default value may be returned.
Simple syntax:
=SWITCH(Value to switch, Value to match1…[2-126], Value to return if there’s a match1…[2-126], Value to return if there’s no match)
Note: Please note that the SWITCH function allows you to test up to 127 different conditions.
DONT CLICK THIS – http://tiny.cc/i650nz
🎥 Excel Advanced Features: https://www.youtube.com/watch?v=Hjm2W03fm-k&list=PLPVQh5aqy-DWfL01ZNWpfV0n5cPME2NzD
🎥 FormulaFriday: https://www.youtube.com/watch?v=7WUR1ZFbDuk&list=PLPVQh5aqy-DXexAZvGbQvTAiBcONNPWHP
👉 Simple way to export out of excel to any Database: https://youtu.be/gDSBFZa3fvE
👉 Arificial intelligence in Excel (Ideas) : https://youtu.be/vJkACTAdPd4
👉 How to use PivotTables in Excel : https://youtu.be/guQMgT-JJiI
👉 Stop using Vlookup, XLookup is here: https://www.youtube.com/watch?v=Hjm2W…
👉 3 must know use cases of Excel Let Function: https://youtu.be/2NFSr3KJ1Z8
source