Returns true if the cell being calculated has a non-formula driven, non-zero value.
HASSTATICVALUE()
Note: Assuming the cell being calculated has a user or process entered value this will return true.