UNARY_PERCENT

divides a number by 100 · from google sheets · no excel equivalent · sheets: not yet compared

signature

UNARY_PERCENT(percentage)

returns: number

argumentrequired
percentage required

examples

formula and result, taken from the engine's own test suite — every result below is asserted in CI, not written by hand.

fx =UNARY_PERCENT(250) 2.5

related

  • ABS returns absolute value of a number
  • ACOS returns arccosine of a number
  • ACOSH returns inverse hyperbolic cosine
  • ACOT returns the arccotangent of a number
  • ACOTH returns the inverse hyperbolic cotangent
  • ADD adds two numbers — sheets exposes the + operator as a function