Hi, I have spent quite some time trying to work out whether there is a formula based on results I already have. It is based on the 2 variables, the Rank (R) and the Number (N) to calculate the Value (V). The results I have are as follows:

R N =V

1 2 =2

2 2 =1

1 3 =3

2 3 =2

3 3 =1

1 4 =4

2 4 =3

3 4 =2

4 4 =1

I want to be able to calculate V based on R and N. I am sure there is blindingly obvious formula for this, but I'm struggling to find it? Can anyone help?

R N =V

1 2 =2

2 2 =1

1 3 =3

2 3 =2

3 3 =1

1 4 =4

2 4 =3

3 4 =2

4 4 =1

I want to be able to calculate V based on R and N. I am sure there is blindingly obvious formula for this, but I'm struggling to find it? Can anyone help?

Last edited by a moderator: