SIGN
Returns the sign of a number. Returns 1 if the number is positive, -1 if negative, and 0 if zero.
Syntax
Examples
|
Formula |
Result |
|
=SIGN(23) |
1 |
|
=SIGN(-3.2) |
-1 |
|
=SIGN(0) |
0 |
Possible Errors
|
Errors |
Meaning |
|
#N/A! |
|
|
#NAME! |
|
|
#VALUE! |
|
|
#REF! |
|
Access your files securely from anywhere
Zoho CRM Training Programs
Learn how to use the best tools for sales force automation and better customer engagement from Zoho's implementation specialists.
Zoho DataPrep Personalized Demo
If you'd like a personalized walk-through of our data preparation tool, please request a demo and we'll be happy to show you how to get the best out of Zoho DataPrep.
- Zoho Workerly Home
- Forums
- Connect With Us:
- Zoho Recruit Home
- Forums
- Connect With Us:
You are currently viewing the help pages of Qntrl’s earlier version. Click here to view our latest version—Qntrl 3.0's help articles.
Zoho Sheet Resources
Zoho Forms Resources
Zoho Sign Resources
Sign, Paperless!
Zoho TeamInbox Resources
Zoho DataPrep Resources
Design. Discuss. Deliver.
Related Articles
Rename a worksheet
To rename a sheet: Click besides the sheet name or simply, right click on the sheet name. Select Rename from the list of options. Alternatively, you can double-click on the sheet name and enter the desired name. Before naming your sheet, please refer ...Use Functions and Formulas
To use a predefined or custom function in your spreadsheet: Double-tap on the cell where you want the result to be displayed. Tap the = sign, then type the desired function's name. While typing, you can also choose from the function suggestions shown ...Use functions and formulas
To use a predefined or custom function in your spreadsheet: Double tap on the cell where you want the result to be displayed. Start with an equal sign (=), then type the desired function's name. While typing, you can also choose from the function ...MOD
Returns the remainder when one integer is divided by another. The result takes the sign of the divisor. Syntax MOD(number; divisor) number: The number whose remainder you want to find. Eg., 25 divisor: The number that you want to divide the ...ODD
Rounds up a given number to the next odd integer, away from zero. Syntax ODD(number) number: The number you want to round up to the next odd integer. Eg., 2.33 Remarks The ODD function rounds up the given number away from zero, irrespective of ...