Here's a much shorter alternative...if you know the maximum values that might occur
In this formula, I'm assuming no more than 5 values
![]()
=SUM(((0&TRIM(MID(SUBSTITUTE(A1,"+",REPT(" ",100)),{1,101,201,301,401,501},100)))^2)/(4*PI()))
Here's a much shorter alternative...if you know the maximum values that might occur
In this formula, I'm assuming no more than 5 values
![]()
=SUM(((0&TRIM(MID(SUBSTITUTE(A1,"+",REPT(" ",100)),{1,101,201,301,401,501},100)))^2)/(4*PI()))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks