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.

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.

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



