ignore null input values and calculate "message" from ranges