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...
-
13:03
NC Dirt Hunter
2 days agoCivil War Metal Detecting with the Xp Deus 2 metal detector.
19.6K3 -
15:01
ScammerRevolts
1 day agoAngry Scammer Laughs After Getting His Files Deleted
7.26K11 -
42:15
Andy Frisella
1 day agoThis Is The Price Of Reaching Your Goals - Ep 731 Q&AF
25.8K9 -
14:52
Fascinating Horror
1 day agoThe Bazar de la Charité Fire | Fascinating Horror
43.9K5 -
16:29
JoBlo Originals
22 hours agoWTF Happened to DAVID LETTERMAN?
31.8K17 -
9:39
Degenerate Jay
1 day ago $0.02 earnedThese Classic Marvel Superhero Games Are Back! - The Marvel Vs Capcom Fighting Collection
44.8K8 -
9:44
Hack
4 days agoDIY Cooling: Homemade Mini Heat Pump (-34°C!) DIY AC Air Cooler ❄️ || DIY Air Conditioner ❄️
36K10 -
2:22:09
Price of Reason
17 hours agoThe Acolyte Episode 5 REACTION, James Gunn Superman CRINGE? Stellar Blade is a HIT! w/ dreadroberts
27.3K -
1:37:16
Steve-O's Wild Ride! Podcast
1 day agoDr. Drew Tells Steve-O Good And Bad News - Wild Ride #221
59.5K11 -
58:07
The Why Files
1 day agoProject 8200 Exposed | CIA Psychics Find Alien Bases Underground
62.9K74