which value is closer

I have four columns. One has an account value. associated with each account is an amount column. Sometimes there are three accounts sometimes two. Then to the right is a column that contains a new value. I need to find which of the original amount value is closer to the new value.