SWITCH Function in Microsoft Excel | Currency Rate Conversion
1 year ago
3
🔴 Ditch the "IF () / IFS()" Function in MS Excel...
One of the popular Logical DAX functions in PowerBI is SWITCH() but few know that this function can be used in Excel as well. (Excel 2019)
Here is a short video of its application
Advantages of using Switch() over IF()..
📍Easy to read the code.
📍We can pass more conditions in the function with better readability.
📍Can be used to write more advanced logics.
1. Currency Rate Conversion
2. Comment on Dates
There are more uses of this function, "Explore the same & Have fun" 😊
Loading comments...
-
12:26
hamak
1 year agoMaking a Currency Converter with Excel Spreadsheets
3 -
5:03
The Excel Zone
1 year agoHOW TO USE CONVERT EXCEL FUNCTION FOR VARIOUS UNIT MEASUREMENTS
36 -
6:09
The Excel Zone
1 year agoIFS EXCEL FUNCTION: THE EASIER WAY TO DO MULTIPLE CONDITIONS
57 -
1:33
syeduddin1786
1 year agoHow To Add Currency Symbol In Excel
22 -
2:38
syeduddin1786
1 year agoIF Function In Excel.
1 -
1:51
syeduddin1786
1 year agoHow To Use The Vlookup Function In Excel.
277 -
1:23
syeduddin1786
1 year agoHow To Convert Negative Values To Positive Values In Excel.
4 -
9:20
The Excel Zone
1 year agoEXCEL TUTORIAL: MASTERING THE IF FUNCTION FOR DATA ANALYSIS - HOW TO SET MULTIPLE CONDITIONS
55 -
1:43
The Excel Zone
1 year agoTEXT TO COLUMNS EXCEL FUNCTION - THE ULTIMATE GUIDE
44 -
12:10
Kaceli TechTraining
9 months agoHow to Use Excel for the Absolute Beginner
4