← All functions

LOG

Quirk found

Category: Math and trigonometry · Last tested 2026-07-04

Support matrix

Engine	Documented	Live-tested	Verdict
Excel	Yes	Not yet	n/a
Google Sheets	Yes	Not yet	n/a
LibreOffice Calc	Yes	Yes (24.2.7.2, 2026-07-04)	Quirk found

Discovered quirks

=LOG(0) on LibreOffice Calc returned #VALUE!, but the documented/expected result is #NUM!. MISMATCH vs expected: expected '#NUM!', got '#VALUE!'
=LOG(-10) on LibreOffice Calc returned #VALUE!, but the documented/expected result is #NUM!. MISMATCH vs expected: expected '#NUM!', got '#VALUE!'

Executed test cases

LibreOffice Calc 24.2.7.2 (tested 2026-07-04)

Formula	Description	Result	Expected	Verdict
=LOG(100)	With base omitted, LOG defaults to base 10	2	2 Microsoft's LOG docs state 'If base is omitted, it is assumed to be 10' -- https://support.microsoft.com/en-us/office/log-function-4e82f196-1ca9-4747-8fb0-6c4a3abb3280	Matched
=LOG(8,2)	Explicit base argument: log base 2 of 8	3	3 This is Microsoft's own documented example: '=LOG(8,2), The result, 3, is the power to which the base must be raised to equal 8' -- https://support.microsoft.com/en-us/office/log-function-4e82f196-1ca9-4747-8fb0-6c4a3abb3280	Matched
=LOG(0)	Zero is outside LOG's domain -> #NUM!	#VALUE!	#NUM!	Mismatch
=LOG(-10)	Negative numbers are outside LOG's domain -> #NUM!	#VALUE!	#NUM!	Mismatch

Docs & syntax

Excel: official documentation
Google Sheets: official documentation
LibreOffice Calc: official documentation