accounting for °F and null values