Challenge #74: Build a Factorial Calculator

[Pete_Rodgers]

i really tried to solve it as an iterative macro, but KISS....

Spoiler

[acarter881]

Here's my second solution (first solution I posted a while ago used the Python tool). I believe the iterative macro is much more efficient than a batch macro since the batch macro has to calculate each factorial up to each number (i.e., it's going to duplicate work). The iterative macro does not have to recalculate any factorials since it is incrementing and validating whether to continue multiplying depending on what number is in a cell. Seems to be significantly more efficient.

Spoiler

[gabrielamitache]

Solution

[TungThanhHo]

my solution

[trapy009]

my solution

[keynguyen]

Spoiler

Spoiler

 

[Kinga]

Hi,

This challenge was very easy to solve without any macro. However, for learning purpose I've created solution based on each type of macro (standard, batch and iterative).

Spoiler

Iterative macro (others are based on non-macro solution):

[saiirangam]

Challenge Completed

[AndrewHoData]

My solution with custom macro icon below

Spoiler

[FinnCharlton]

Spoiler