=SIGN(number)

The official SIGN reference explicitly shows =SIGN(23) → 1, =SIGN(-3.2) → -1, and =SIGN(0) → 0. No optional mode or tolerance parameter is documented. In particular, SIGN treats zero as a separate category, not positive and not negative.

The public function documentation describes the currently available Zoho Sheet function but does not establish a first release date or an exhaustive browser/desktop/mobile parity matrix. Do not label this function as natively tested on a platform based only on reading help articles.

Use math-sign-and-rounding-practice.csv included in the batch. Paste it at A1. The key columns are A = ID and B = Variance; B values must be real numbers. The eight rows intentionally include both signs, zero and a small negative number so the example distinguishes a zero from a rounded-to-zero display.

Step by step: label the direction

1. Set E1 to Direction code.
2. Enter =SIGN(B2) in E2. Independently, the answer is -1.
3. Copy E2 through E9 and compare with the table above.
4. Set F1 to Direction label.
5. Put the following formula in F2, then fill down:

=IF(SIGN(B2)<0;"Below target";IF(SIGN(B2)>0;"Above target";"On target"))

The predicted label in F2 is Below target; F3 is Above target; F4 is On target. For an organization where negative inventory variances indicate shortages, those labels could instead say Shortage, Surplus, and Balanced. This is a change to the business labels, not to SIGN’s numerical behavior.

A tiny negative number may be operationally irrelevant. If the policy is to flag a shortage only when the deviation is more than 10 units, use:

=IF(ABS(B2)<=10;"Within tolerance";IF(SIGN(B2)<0;"Investigate shortage";"Investigate surplus"))

With B2 = -14.75 this independently predicts Investigate shortage. With B3 = 8.20, it gives Within tolerance, and with B6 = 12.49 it gives Investigate surplus. In contrast, with B8 = -0.04 it gives Within tolerance, although SIGN(B8) remains -1. This difference is intentional: SIGN reports direction, while ABS checks magnitude.

Make the threshold editable by entering 10 in H1 and replacing 10 in the formula with $H$1. This makes the policy transparent to nontechnical reviewers and avoids inconsistent hard-coded thresholds across rows. The formula has not been executed in Zoho Sheet, so final validation should check IF, ABS, SIGN and the locale’s argument separator together.

You can also calculate a normalized direction code for a difference between two figures: =SIGN(C2-C3) gives 1, since C2 = 25 and C3 = -23. A negative answer would mean the first value is smaller than the second. A direction-only signal is not a substitute for the actual difference =C2-C3 when reporting the quantity of change.

• Zero is different from a blank. The official SIGN article specifies the output for numeric zero. It does not establish every rule for empty cells, empty-string formulas or whitespace-only strings. Validate how your actual imported dataset represents missing values before treating a blank as zero.
• Displayed zero may not be numeric zero. A cell showing 0.00 could contain a small value such as -0.004 and produce -1. Inspect the full precision of the input when results seem surprising.
• Positive and negative infinity, errors, and complex values are not covered by the normal examples. Do not invent special-case support or treat such results as verified.
• Direction depends on subtraction order. SIGN(Actual-Target) and SIGN(Target-Actual) reverse the direction for nonzero differences. Decide and document the sign convention before copying formulas.

Zoho’s generic error legend includes #N/A! although SIGN does not perform a lookup; do not interpret that boilerplate as meaning a missing match is normal for this function.

Microsoft Excel documents a comparable SIGN function returning -1/0/1 and uses comma-separated English examples. Zoho’s SIGN reference has only one argument, so list separators do not affect the stand-alone SIGN call; the multi-argument IF examples above follow the semicolon notation shown throughout the Zoho help pages reviewed for this batch. Some software or locale setups use commas; verify the active editor’s requirements before bulk pasting.

For magnitude, use ABS. For the integer part of a number, compare INT and TRUNC; neither is a replacement for a sign test. For cyclic grouping, MOD solves a different problem: division remainders. These proposed related URLs require manual owner review before site publication.

• Zoho Sheet — function documentation

Verification status: Official documentation checked; example outcomes were independently reasoned or arithmetically checked where applicable. Not executed in Zoho Sheet.

• No genuine Zoho Sheet screenshots are included; this guide does not use mock application images.