Type the Excel formula that converts a Canadian-dollar amount in B2 to US dollars, with the rate in CAD per USD in B3.

Answer

=B2/B3

CAD ÷ (CAD/USD) = USD — the CAD cancels. 5,000 ÷ 1.36 = 3,676.47. Going the other way, USD × (CAD/USD) = CAD.

Bank of Canada, "Understanding exchange rates" (bankofcanada.ca, 2020) and "Understanding how monetary policy works" (2021) — adapted with attribution and changes; Bank of Canada content is available free of charge at bankofcanada.ca; last intervention September 1998 per the explainer (verified-facts §2.6 F26); every conversion original