LinkBack URL
About LinkBacks
The formula I started with was
=SUMPRODUCT(MID(A2, RowVec(1, LEN(A2)), 1) * 2^RowVec(LEN(A2) - 1, 0))
... but that uses a UDF. INDIRECT is compact but volatile.
The formula I started with was
=SUMPRODUCT(MID(A2, RowVec(1, LEN(A2)), 1) * 2^RowVec(LEN(A2) - 1, 0))
... but that uses a UDF. INDIRECT is compact but volatile.
Last edited by shg; 11-09-2017 at 01:43 PM.
Entia non sunt multiplicanda sine necessitate
Here is a non-volatile version:
=SUMPRODUCT(MID(A1,ROW(A$1:INDEX(A:A,LEN(A1))),1)*(2^(LEN(A1)-ROW(A$1:INDEX(A:A,LEN(A1))))))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks