The range is calcualted by sorting the data from lowest to highest and then subtracting the lowest number from the highest.
If you are recieving conflicting solutions it may be due to an extra space in the field. Every space will ad another data point, even if that may not be what you intended.