The adjustment log mixes changes of different sizes. Add a direction flag to group decreases, unchanged quantities and increases while keeping the actual changes.

Handle the input before calculating the sign

If the numeric change is in B2, put this in C2 and fill down:

=IF(ISNUMBER(B2),SIGN(B2),"")

A decrease of −12 maps to −1, zero maps to 0 and an increase of 4 maps to 1. A missing or nonnumeric value returns a blank result.

Sample adjustments of −12, 0 and 4 map to direction flags −1, 0 and 1.

Illustrated mapping. Magnitude remains in the source column.

Check zero and a missing row separately

Use one real zero and one blank input. The results should be 0 and blank. If a calculation produces tiny residuals, decide whether your process has a rounding rule before applying SIGN. Keep the full adjustment next to the flag for review.

A validation table shows an unknown input left blank and a measured zero producing the zero flag.

Illustrated check. Keep a missing value separate from a real zero.

Microsoft’s SIGN function reference.