Skip to content
Excel

SIGN function in Excel

Returns the sign of a number

=SIGN(number)

SIGN syntax and parameters

One argument, one required.

  • numbernumberRequired

    Any real number.

SIGN examples

Formulas you'll actually reuse.

  1. −1, 0, or 1 for below, on, or above target:

    =SIGN(B2 - C2)

    Result1

  2. How many rows came in under target:

    =SUMPRODUCT(--(SIGN(B2:B50 - C2:C50) = -1))

    Result12

SIGN in Google Sheets

Same name — your formula ports as-is.

Try SIGN in the playground

Edit the example — nothing to install.

Preloaded with the SIGN formula from Example 1 — change anything and watch it respond.

Loading the editor…

Related functions

More ways Excel gets this done.