• where is the logical value TRUE or FALSE.
    • GOLDENRATIO() returns the ratio of the longer part divided by the smaller part is also equal to the whole length divided by the longer part.


  • Two quantities are in the golden ratio if their ratio is the same as the ratio of their sum to the larger of the two quantities.
  • Golden ratio is represented as φ(phi or Smallphi) and its conjugate is represented as Φ(Phi or capitalphi).
  • If 'a' and 'b' are two quantities with 'a>b', then
φ =   =  
  • Using quadratic formula, golden ratio is represented as -
  =   = 1.618033988749895 
  =   = -0.6180339887498948 (Absolute value 0.6180339887498948 is considered as capitalphi)
  • Argument   can be logical values TRUE (or 1) or FALSE (or 0). Any other argument values are ignored and Calci assumes it to be TRUE or 1.
  • If argument   is omitted, Calci assumes it as TRUE or 1 and displays the output as 0.6180339887498948.
  • If argument is invalid, Calci returns a #NULL error message.


GOLDENRATIO(TRUE) returns 0.6180339887498948, value of capitalphi Φ

GOLDENRATIO(1) returns 0.6180339887498948, value of capitalphi Φ

GOLDENRATIO(FALSE) returns 1.618033988749895, value of smallphi φ

GOLDENRATIO() returns 0.6180339887498948, value of capitalphi Φ

Related Videos


See Also