Why does the the following Formula Work if the Result is Displayed in Next To Adjacent Column ?

[RapchikM]

Hello

Why does the the following Formula Work if the Result is Displayed in Next To Adjacent Column ?

Formula written in E5, F5, G5, H5 for the Value in D5
=IFERROR(MID($D5,COLUMN()-(COLUMN($D5)-0),1)+0,0)

D5 VALUE = 7691
E5 = 7
F5 = 6
G5 = 9
H5 = 1

If i shift the above formula with respective column refernce nos to E10, F10, G10, H10
the value in each above reference column/cells displays 0 or Zero
For eg Formula Copied from E10 to H10
=IFERROR(MID($D5,COLUMN()-(COLUMN($D5)-0),1)+0,0)

Why ?

Any Wrong thing or wrong reference am I incorporating

Your input shall be appreciated

Thanks
RapchikM

 

[RapchikM]

Etaf
Thank you so much for the pain taken to Explain each part.

whne in cell L5
MID($D5,COLUMN()-(COLUMN($D5)-0),1)+0
which converted to numbers is
the same as typing
MID($D5,8,1)+0

in M5
MID($D5,9,1)+0

in N5
MID($D5,10,1)+0

in O5
MID($D5,11,1)+0

Unfortunately The above also turned the resulto 0 /zero

Now When i used the Following It worked Ofcourse with your detailed explanation
L5
=IFERROR(MID($D$5,1,1)+0,0)
M5
=IFERROR(MID($D$5,2,1)+0,0)
N5
=IFERROR(MID($D$5,3,1)+0,0)
O5
=IFERROR(MID($D$5,4,1)+0,0)

FYI there was no need for Substraction of Column L =12 and Column D = 4 and taking value as 8.
Although different method to adopt Which could be rather confusing.

The MID$ did the trick of taking the position

The above remains as Final Formula From L5:O5

Thanks

RapchikM

 

[etaf]

You don’t need the +0 part

Other wise you are welcome