Hi Sam,
The Min and Max in the MapRange Node are badly named. Min can be larger than Max. I always think of it as From A to A and From B to B.
In your upper Screenshot of your Nodes, for instance, your Input is 1.6:

In the Map Range, you go from 0.8 to 0 and from -0.8 to 1. This means that the Input Value of 1.6 becomes and Output Value of -0.5.
(If you would turn on Clamp in the Map Range Node, that would be clamped to the [To Min, To Max] range, meaning it then would be 0.0)
The Color Ramp however Clamps its Input to a [0, 1] range, meaning -0.5 becomes 0.