The formula works when the SUM is composed of 1+0.11, but not 3.11-2. Different number combinations work/don't work with seemingly no consistency.
The formula works when the SUM is composed of 1+0.11, but not 3.11-2. Different number combinations work/don't work with seemingly no consistency.
Hi Benthreinen,
Welcome to the forum.
this line should be "but not 4.11-3" .. correct ?but not 3.11-2
Making myself an interested party here..
Regards,
DILIPandey
<click on below 'star' if this helps>
DILIPandey, Excel rMVP
+919810929744 (India), +971528225509 (Dubai), dilipandey@gmail.com
Correct that's the combination on the attached, but it's both combinations actually. Feel free to try out any number of different numbers that sum to any of the numbers in Column A. I couldn't find any kind of pattern.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks