I added range 4... the math doesn't add up.
I have no idea how you can possibly say that the math doesn't add up, when you don't even know the equation to use. If you were using the right equation, then you can be certain that the math would work out.