Type the Excel formula that converts a nominal GDP in B2 to real GDP, with the deflator (base = 100) in B3.

Answer

=B2/(B3/100)

Nominal ÷ (deflator/100): 2,900 ÷ 1.16 = 2,500. Dividing by the deflator strips out price changes, leaving the quantity.

OpenStax, Introduction to Business (CC BY 4.0) §1.4 — cycle and indicator shape only; real-GDP arithmetic and every figure original; the indicator classification is taught as a concept, not tied to any current Statistics Canada composite