Apple Numbers CURRENCYCONVERT Function: Currency Context and Rate Controls

The official CURRENCYCONVERT reference was retrieved October 15, 2026. The original function-introduction release and last functioning version are unknown from the checked sources. Current shared function documentation is not a last-working-build test or evidence of identical behavior on every older Mac, iPad, iPhone and iCloud client.

No native Numbers session was executed. The examples use independent arithmetic or constrained text models, with data-dependent results identified explicitly. Public-source retrieval is separate from native verification.

CURRENCYCONVERT(value, currency-code)

value supplies the amount to convert. If it is not already a currency value, Apple uses the default currency associated with the applicable language and region. currency-code identifies the target currency, using an ISO 4217 code such as EUR or USD.

The dedicated page contains a one-argument example even though its argument list describes the target-code argument without an explicit optional/default rule. This guide supplies both arguments and does not infer a universal omitted-target behavior from that example.

In Apple’s pound-text example, =CURRENCYCONVERT("£6","EUR") returns the euro value of six pounds at the previous market close. The exact number changes with the retrieved rate; no current exchange quote is asserted here.

Apple also gives =CURRENCYCONVERT(C3,"USD") when C3 contains the currency value ¥5 and the context is Chinese (Simplified, China mainland). That stated context identifies the yuan input. It should not be changed to an arbitrary text string or a different region while retaining the same expected source currency.

Use a separate deterministic fixture to check the arithmetic around a conversion. Assume, solely for this fictional control, 1 GBP = 1.20 EUR. This is not a retrieved market quote.

Put source amounts in A2:A5 and the fixed assumption 1.20 in B1. A plain arithmetic control =A2*$B$1, filled down, produces those targets. It does not invoke CURRENCYCONVERT or claim to override the service’s exchange rate.

If a captured conversion quote were exactly 1.20 EUR per GBP, these would be the corresponding multiplication targets. Retain that conditional wording when comparing a service result with a fixed model.

With the same fictional quote, converting 120 EUR back to GBP by arithmetic gives 120/1.20 = 100 GBP. Multiplying 120 by 1.20 instead gives 144 and uses the wrong direction for this stated rate.

Record rate units explicitly as “EUR per GBP,” rather than labelling a column merely “rate.” A reverse market quote need not be guaranteed to equal an exact mathematical reciprocal after provider rounding or differing observations; the reciprocal above is only the fixed control’s identity.

For 100 GBP, the fixed assumptions 1.18, 1.20 and 1.22 EUR per GBP produce 118, 120 and 122 EUR. The difference between the first and last scenarios is 4 EUR.

These scenarios help verify a report’s sensitivity without claiming that any of the three rates is current. If an actual result differs, inspect the source currency and the quote’s effective market date before concluding that the multiplication is wrong.

Previous market close is not necessarily yesterday’s calendar date. Weekends and market holidays can make those descriptions differ. The source does not provide a complete refresh timetable or promise a real-time executable transaction rate.

For a reproducible report, retain the source amount, source currency, target currency, observed converted amount and the date/context of the observation. This guide did not retrieve a native quote or create such a snapshot; it specifies the information needed to audit one.

Check the input’s actual currency type and the document’s language/region setting if a plain number converts from the wrong denomination. Formatting an amount with a symbol does not by itself prove that the intended stored currency context was established.

The dedicated page identifies remote internet data but does not supply an exhaustive native error-code matrix for unsupported codes, failed retrieval, malformed text or offline behavior. Do not copy a related function’s exact outage response into this one without evidence.

A displayed conversion is an informational spreadsheet result. It does not include a guaranteed bank quote, fees or a promise that a transaction can be completed at that rate. Verify those separately when they matter to the user’s actual calculation.