Excel Formula Challenge #8
Here is another formula challenge for all excel lovers, by using only excel native formulas, you need to get the result in second column. formula should work at least 1 to 100 number.
Conditions : No Helping columns
Try yourself first, then see the solution here, I would love to see your see your solution in comment box.
Excel Formula Challenge #8 Solution (48 downloads)
Edits : pls ignore spelling mistake in image.