Amounts in column B are USD. Convert to EUR using a rate in $E$1

公式

=B2*$E$1

说明

Keep the FX rate in one input cell and lock it with $E$1. Never hard-code the rate inside every row so you can refresh prices in one place.

步骤

  1. Store the USD→EUR rate in E1.
  2. Multiply each USD amount by $E$1.
  3. Round display with ROUND if you issue invoices.

变体

Round to cents

Banker’s display; see MROUND if you need nickel increments.

=ROUND(B2*$E$1, 2)

Rate table lookup

C2 is the target currency code. Rates sheet has code → rate.

=B2*VLOOKUP(C2, Rates!A:B, 2, FALSE)

Convert only if currency is USD

Leaves already-local amounts unchanged.

=IF(C2="USD", ROUND(B2*$E$1, 2), B2)