3/ How it works:
→ Looks at the currency column
→ USD? Multiply by 1,000
→ KES? Multiply by 6
→ NGN or GBP? Returns
#N/A (not listed = no rule = no result)
4/ That
#N/A was actually a great teaching moment. it showed us that SWITCH only handles cases YOU define.