GCD in Apple Numbers: Greatest Common Divisor and Examples

GCD returns the greatest common divisor (also called the greatest common factor) shared by numeric inputs. For example, the expected value of =GCD(48,18) is 6, because 6 is the largest positive integer dividing both exactly. Apple documents one or more numbers and accepts numeric collections such as a cell range. [A1, M1]

Official Apple syntax and arguments

=GCD(num-value, num-value…)

Apple defines the first num-value as required, with optional additional num-value inputs. Each may be a number or a collection of numeric values. Decimal portions are ignored, so 24.9 and 36.8 are treated as 24 and 36 for the independent expected result 12. No optional argument has a default numerical value: omitting extra arguments means there simply are no additional inputs. Apple’s entry does not fully specify every edge case involving empty ranges, negative values, zero, data types or error strings, so those must not be presented here as observed behaviour. [A1]

The English function name above appears in Apple’s Formulas and Functions Help 15.4, consulted on 2026-10-12T02:47:22Z UTC. The help-edition number identifies the documentation that was checked; it does not establish the minimum Numbers application version, the introduction date, identical availability on macOS, iOS, iPadOS and iCloud.com, or a translated function-name alias. Those details require platform-specific verification before a compatibility claim is published. No official English alternative function name was found in the checked catalogue. [A1, A2]

Apple’s standard function examples separate arguments with commas. If your system’s decimal separator is a comma, Apple instructs you to use semicolons between arguments entered manually. In that setting, a formula written here as =GCD(24,36) may need =GCD(24;36); the appropriate decimal notation for 24.5 will also differ. Enter the function from Numbers’ Functions Browser to avoid locale-related typing mistakes. [A3]

A same-table formula can refer to B2; a range is B2:B6. When a function is entered in a different table, select the source cells with the editor so Numbers inserts a qualified reference such as SourceTable::B2 or Sheet 2::SourceTable::B2. The exact sheet/table names depend on the workbook. Apple documents :: as the cross-table/sheet qualifier; Excel Sheet1!A1 syntax is not the same. [A4]

Validation status: Official Apple documentation checked; example outcomes independently reasoned and calculated in Python, except where clearly labelled an Apple-documented error. Not executed in Apple Numbers. Numerical outcomes below are expected, not observed app results. No genuine Numbers screenshots were available; this guide contains no mock application images.

Create a Numbers table CommonFactors with B1=First number, C1=Second number, D1=GCD. Enter the numeric B/C values below, set D2 to =GCD(B2,C2), and fill down. All D values below are expected mathematical results independently calculated in Python, not observed Apple Numbers output. [A1, M1]

Row: 2

B
48

C
18

D formula
=GCD(B2,C2)

Expected D
6

Row: 3

B
14

C
21

D formula
=GCD(B3,C3)

Expected D
7

Row: 4

B
24.9

C
36.8

D formula
=GCD(B4,C4)

Expected D
12

Row: 5

B
15

C
25

D formula
=GCD(B5,C5)

Expected D
5

Row: 6

B
64

C
96

D formula
=GCD(B6,C6)

Expected D
32

Row: 7

B
99

C
102

D formula
=GCD(B7,C7)

Expected D
3

Row: 8

B
17

C
29

D formula
=GCD(B8,C8)

Expected D
1

To independently reproduce the 48/18 result, list divisors of 48 (1,2,3,4,6,8,12,16,24,48) and divisors of 18 (1,2,3,6,9,18). Their largest overlap is 6. For the decimal case, Apple’s documented behaviour discards fractional portions before calculating the divisor; it does not find a fractional common divisor. [A1, M1]

Accept more than two numbers

Enter =GCD(99,102,105) into a separate formula cell: the expected answer is 3 and matches Apple’s example. Create a distinct one-column table Divisors, with 18 in B2, 30 in B3 and 42 in B4. From the same table use =GCD(B2:B4); the expected result is 6. A range is one collection argument, so additional explicit numbers are not needed. [A1, A4, M1]

Simplify a fractional ratio

Suppose a rectangular artwork is 18 units wide and 24 units high, and you want the smallest integer ratio preserving its shape. Put B2=18 and C2=24 in a table named Ratios. In D2 compute =GCD(B2,C2) for expected 6; E2==B2/D2 gives 3; F2==C2/D2 gives 4. Therefore 18:24 simplifies to 3:4. This assumes nonzero positive integer dimensions; a zero divisor or noninteger measurements require a separate data-quality rule. [M1]

Find a shared grid or cut interval

Stock lengths of 24 and 36 centimetres can be divided into equal 12 cm integer-sized pieces without leftover stock. =GCD(24,36) has expected 12. Dividing each original length by 12 gives 2 and 3 segments respectively. This use assumes no cutting loss/kerf and measurements already in the same unit. If measured inputs have decimals, Apple’s truncation behaviour could discard material precision; convert to an integer base unit (for example, measured millimetres) first instead of supplying decimals blindly. [A1, M1]

Reconcile with the related LCM function

For positive whole values a and b, the identity GCD(a,b) × LCM(a,b) = a × b provides a useful numeric check. For 12 and 18: GCD(12,18) is 6, LCM(12,18) is 36, and 6×36=12×18=216. The arithmetic was independently calculated; it is not an Apple app-level assertion for every numeric type or zero/negative edge case. [M1]

Cross-table calculations

If CommonFactors is on another sheet or in another table, construct the reference by choosing B2:C2 with Numbers’ Formula Editor. A range is B2:C2 inside the same table; a qualified reference can be CommonFactors::B2:C2. Naming and qualifiers are not copied from Excel’s Sheet!Cell notation. [A4]

In particular, no exact error string, behavior for =GCD(0,0), or behavior for negative inputs is claimed. Python’s math.gcd() can independently check the positive test vectors, but it cannot certify Numbers-specific coercion and edge cases.

Both Microsoft Excel and Google Sheets document a function named GCD for greatest common divisors. The common positive integer examples above have the same mathematical meaning in those products. However, Numbers explicitly accepts its own cell-collection syntax and its documentation on fractional portions must not be generalized to all other engines without their specific help pages. Error messages, blank/text handling, locale punctuation and platform-specific support need separate checking. [X1, X2]

Apple LCM calculates the smallest common multiple, while Apple GCD provides the authoritative argument and range rules. [A1]

• [A1] Apple, GCD, Formulas and Functions Help 15.4 (accessed 2026-10-12T02:47:22Z). Official function article. Claim support: syntax, argument requirements, documented examples and domain/behaviour notes; see the article’s main-content 428–445 main-content lines in the collected research evidence.
• [A2] Apple, List of functions by category, checked 2026-10-12T02:47:22Z. Confirms the English canonical function name and its Numeric grouping, but is not a minimum-version compatibility matrix.
• [A3] Apple, Functions overview, checked 2026-10-12T02:47:22Z. Confirms required vs optional argument notation, case-insensitive function spelling and comma/semicolon conventions.
• [A4] Apple, Refer to cells in formulas and Types of arguments and values, checked 2026-10-12T02:47:22Z. Explains ranges, qualified table references, numeric values and collections.
• [X1] Microsoft, Excel math and trigonometry reference, checked 2026-10-12T02:47:22Z. Confirms the presence of the same named function; engine-specific coercion and corner cases are not assumed identical.
• [X2] Google, Google Sheets function list, checked 2026-10-12T02:47:22Z. Confirms name/purpose; Sheets syntax and locales should be checked in a Sheets workbook.
• [M1] Independent Python standard-library computation performed for the explicit numeric test vectors recorded in the accompanying JSON evidence; no Apple Numbers application execution.

• FACT — continue with a related Apple Numbers calculation.
• FACTDOUBLE — continue with a related Apple Numbers calculation.
• COMBIN — continue with a related Apple Numbers calculation.
• COMBINA — continue with a related Apple Numbers calculation.
• PERMUT — continue with a related Apple Numbers calculation.

For a software-specific comparison: LibreOffice Calc GCD, Apache OpenOffice Calc GCD, Gnumeric GCD. A shared name does not establish identical argument, error or version behaviour.

The linked official function documentation was reviewed on October 12, 2026. Apple’s Formulas and Functions Help 15.4 identifies the documentation edition, not a minimum Numbers release or a guarantee of historical platform parity. Selected worked examples were checked using independent mathematical or text-processing models; results are expected values, not observations from the spreadsheet application. Native Apple Numbers execution was not performed. Undocumented coercion, exact error messages and platform-specific behaviour remain unverified.

View reproducible example inputs and independent check results. This record is not a native spreadsheet test log.