A possible problem can occur with your first formula =IF(E100>0,E100,” “). This will return " " (a text space) if C12 is not greater than 0. In your later formula you will then be trying to use text to be greater than 0. Try inserting a zero instead of " ".
Surface Pro (2017) vs Surface Pro 4