Go Back

How to Use the Excel Sign Function

We can use the excel sign function to return the sign of a number. The sign function returns:

  • Number zero as 0
  • A positive number as 1
  • A negative number as -1

The steps below will walk through the process.

Figure 1: How to Use the Excel Sign Function





Setting up the Data

  • We will set up the data by inputting the NUMBERS into Column A
  • Column B is where we want the SIGN FUNCTION to return the result

Figure 2: Setting up the Data

Using the Excel Sign Function

  • We will click on Cell B4
  • We will insert the formula below into the cell
  • We will press the enter key

Figure 3: Result of the Sign Function for Cell A4

  • We will click on Cell B4 again
  • We will double-click on the fill handle (the small plus sign at the bottom right of Cell B4) and drag down to copy the formula into the other cells

Figure 4: Result of the Sign Function for Column A

Instant Connection to an Expert through our Excelchat Service

Most of the time, the problem you will need to solve will be more complex than a simple application of a formula or function. If you want to save hours of research and frustration, try our live Excelchat service! Our Excel Experts are available 24/7 to answer any Excel question you may have. We guarantee a connection within 30 seconds and a customized solution within 20 minutes.

Did this post not answer your question? Get a solution from connecting with the expert.

Another blog reader asked this question today on Excelchat:
Here are some problems that our users have asked and received explanations on

I want to set a price on an excel sheet but I can't select a sign it only goes a $ sign
Solved by G. C. in 13 mins
I want help so i can make a formula that will compare numbers in two cells and if they are equal to display an equals sign. if one is less to display a minus sign and if one is bigger to display a plus sign
Solved by M. J. in 16 mins
Must start with an equal sign G). You can entera formula with + sign from the number pad; and Exce/ wi// convert it to an = sign. Add + (cell A3) Subtract -B 1 (cell C 1) Multiply (cell DI) Divide =AI/BI (cell El)
Solved by D. A. in 12 mins

Leave a Comment