need calculation for below

[JAVEDR]

Hello, need calculation for below table i have values in column B which need to calculation in below manner to get result for highlighted cell -

note highlighted in red value need to come trough formula , text highlighted in white value we don't have, text highlighted in bold total is same calculation are based on like this ===

	2	0			2	8			0	2			2	7
0	2	8		2	0	2		8	2	7		3	9	8
2	0	2		8	2	7		3	9	8		2	7	5
8	2	7		3	9	8		2	7	5		5	2	9
7	9			2	7			5	2			1	1

	2	0			2	2+0=2
0	2	8		2+0=2	2	2+8=0
2	0	2		0+2=2	0	0+2=2
8	2	7		2+8=0	2	2+7=9
7	9			2+7=9	9

 

[Peter_SSs]

Try this then.

JAVEDR.xlsm
	A	B	C	D	E	F	G
1		2	0			2	8
2	0	2	8		2	0	2
3	2	0	2		8	2	7
4	8	2	7		3	9	8
5		9				7
Sheet1

Cell Formulas
Range	Formula
A2:A4,E2:E4	A2	=MOD(B1-B2,10)
C1:C4,G1:G4	C1	=MOD(B2-B1,10)

 

[Peter_SSs]

I think this needs better explanation. You thread has had more than 40 views yet nobody has offered anything. I didn't understand the explanation so I assume the other 40+ people didn't either.

 

[JAVEDR]

Ok Sir,

 

[JAVEDR]

I think this needs better explanation. You thread has had more than 40 views yet nobody has offered anything. I didn't understand the explanation so I assume the other 40+ people didn't either.

Sir,

	7	3			A	B
7	0	6		C	D	E
4	6	7		F	G	H
3	3	0		I	J	K
0	3			L	M
				HIGHLIGHTED IN YELLOW VALUE I HAVE
				A+B = D		C+D=A
				D+E =G		F+G=D
				G+H =J		I+J=G
				J+K =M		L+M=J

 

[Peter_SSs]

Still not very clear but is it this?

JAVEDR.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O
1		2	0			2	8			0	2			2	7
2	0	2	8		2	0	2		8	2	7		3	9	8
3	2	0	2		8	2	7		3	9	8		2	7	5
4	8	2	7		3	9	8		2	7	5		5	2	9
5	7	9			2	7			5	2			1	1
Sheet1

Cell Formulas
Range	Formula
B2:B5,N2:N5,J2:J5,F2:F5	B2	=MOD(B1+C1,10)

 

[JAVEDR]

Still not very clear but is it this?

JAVEDR.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O
1		2	0			2	8			0	2			2	7
2	0	2	8		2	0	2		8	2	7		3	9	8
3	2	0	2		8	2	7		3	9	8		2	7	5
4	8	2	7		3	9	8		2	7	5		5	2	9
5	7	9			2	7			5	2			1	1
Sheet1

Cell Formulas
Range	Formula
B2:B5,N2:N5,J2:J5,F2:F5	B2	=MOD(B1+C1,10)

thank you sir for your reply and time. highlighted yellow value i.e B2:B5,N2:N5,J2:J5,F2:F5 i have i need formula for C1:C4 AND A2:A5

 

[Peter_SSs]

What values do you start with then?

 

[JAVEDR]

Sir, Column B1, B2, B3, AND B4 contains 2/2/0/2 then we have to start with C1 which is 0 it came because b1 what value we will add for b2 i.e0 )

 

[Peter_SSs]

OK, that gives some idea about column C.

What about column A?
In particular, why is this highlighted value 0?