<
<

Apply Sign Function

>

Map all positives to 1 and negatives to -1.

>

Input

Output

33 Related tools

Table Statistic?

Any Questions?

Map all positives to 1 and negatives to -1. Sign function is a mathematical function that determines the sign of a number. Read more about sign on Wikipedia https://en.wikipedia.org/wiki/Sign_function

The sign of -3 is -1, because the sign function returns -1 for negative numbers, 0 for zero, and 1 for positive numbers.

Useful in identifying the sign of numbers in a dataset.

  • Microsoft Excel: SIGN
  • Google Sheets: SIGN
  • Apple Numbers: SIGN
  • Python Pandas: np.sign(s)
  • Related Words: apply sign function, determine the sign of each element

This is normal for a web based application. We recommend uploading data up to 6000 columns and rows. If you encounter lag, you can reduce the sheet size.

There is a fullscreen button on the top right side of the input table. You can also download the table offline to edit with excel which has bigger screen sizes.

You can leave a message here.

Why SickSheet?

🌎
Access Anywhere

Compatible with any browser on any systems. No installation needed.

💸
Free to Use

Use over 300+ tools for free. No registration or credit card asked.

🧸
No Code

Complete all process without writing a single line of code.

💡
Intuitive Edit

Editing tables feels like in Excel. No learning curve needed.

💾
Instant Download

Click to download 10+ Spreadsheet formats and continue edit in Excel.

🕵️‍♂️
Super Private

Nothing is sent to the server. All data are operated on the client-side.

Related Tools?

Apply Addition

Add a specified number to the entre table.

Apply Subtraction

Subtract a specified number from the entire table.

Apply Multiplication

Multiple a specified number with the entire table.

Apply Division

Divide a specified number from the entire table.

Apply Absolute Function

Returning the positive value of each number.

Apply Negation

Invert the numbers in a table.

Apply Modulo

Finding the remainder after division by a specified value.

Apply Logarithmic Function

Calculating the logarithm value for each number.

Apply Exponential Function

Raising each number to the power of any number.

Apply Power Function

Apply the power function using each number of the table.

Apply Root Function

Finding the square root or nth root of each number.

Apply Sine Function

Apply the sine function to numbers in a table.

Apply Tangent Function

Apply the tangent function to numbers in a table.

Apply Cosine Function

Calculating the cosine value for each number.

Apply Factorial Function

Calculating the factorial result for each number.

Apply Normalization

Scaling numbers to a common range or format like 0 and 1.

Limit Maximum Number

Clip the maximum value of a table to a specified threshold.

Limit Minimum Number

Clip the minimum value of a table to a specified threshold.

Map Text To Length

Converts each value to their text length.

Map Text To Word Count

Counts the amount of words in every cell.

Map To Percent

Convert absolute numbers to their percent numbers.

Truncate Cell

Shortens cell content to a set length like "A sentence...".

Map To Reversed

Reverse the order of letter in a text.

Map To Shuffled Character

Randomizes character order within cells.

Map To Shuffled Word

Randomizes word order within cells.

Map To Shuffled Sentence

Randomizes sentence order within cells.

Add New Line To Sentence

Appends a newline at the start of sentences.

Compute Days Until Date

Counts days from today until the specified date.

Compute Days Since Date

Counts days since the given date up to today.

Round Number

Round numbers in a table to the nearest number.

Round Up Number

Round up numbers in a table to the nearest number.

Round Down Number

Round down numbers in a table to the nearest number.

Reformat Date

Changes date entries to a different format like yyyy-mm-dd.

<
👉... other 321 tools to save you time
>