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]

{A3 value 4 came from b3 (6)+b2 (0)}

How does 6 + 0 give 4?

need formula for ... A2:A5
Kindly ignore highlighted value 0 (A5)

How would we determine a formula for A5 if we are to ignore it?

 

[JAVEDR]

How does 6 + 0 give 4?


How would we determine a formula for A5 if we are to ignore it?

{A3 value 4 came from b3 (6)+b2 (0)}

How does 6 + 0 give 4?

In 6 if we add 4 then it is 0 (10 i have taken 0)

For A5 we can keep it blank means no formula

 

[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)

 

[JAVEDR]

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)

excellent sir , thanks a lot

 

[Peter_SSs]

You're welcome. Glad we got there in the end. Thanks for the confirmation.