GCD_ADD

Returns the greatest common divisor of two or more integers. (inc negative numbers)

link - wiki.documentfoundation.org/Documentation/Calc_Functions/GCD_EXCEL2003 
link - help.libreoffice.org/latest/en-US/text/scalc/01/04060106.html

Microsoft Excel

The GCD function in Excel returns an error if any of the arguments are negative values.

GCD(-8, 16) = #NUM! 

LibreOffice Calc

The GCD function in LibreOffice returns a value if any of the arguments are negative values.

GCD(-8; 16) = -8 

The GCD_ADD or GCD_EXCEL2003 function in LibreOffice provides an identical function to Excel.

GCD_ADD(-8; 16) = #NUM! 
GCD_EXCEL2003(-8; 16) = #NUM!

© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited TopPrevNext