ABSZERO

Returns the value of Absolute Zero in degree Celsius or degree Fahrenheit. This is equivalent to 0K (Kelvin).

Absolute Zero is the lowest temperature theoretically possible, characterized by complete absence of heat (internal energy). Absolute zero is approximately -273.15 degree Celsius, or -459.67 degree Fahrenheit.

Syntax

ABSZERO(si_unit)

si_unit - Optional. An integer value of either 0 or 1. Decides whether the answer should be returned in degree Celsius (0) or degree Fahrenheit (1). Default is 0, if omitted.

Example

=ABSZERO() returns -273.15
=ABSZERO(1) returns -459.67