Functions
GCD
Greatest common divisor
Try it
When to use it
When is GCD useful in a spreadsheet?
Use GCD to simplify fractions, find common packaging units, or determine the largest batch size that divides evenly into multiple quantities.
Used in
Syntax
GCD(value1,...)Examples
=GCD(24,36) // => 12
=GCD(24,96,48) // => 24
=GCD(12,4) // => 4