How to resolve the algorithm Multiplication tables step by step in the Excel programming language

Published on 12 May 2024 09:40 PM
#Excel

How to resolve the algorithm Multiplication tables step by step in the Excel programming language

Table of Contents

Problem Statement

Produce a formatted   12×12   multiplication table of the kind memorized by rote when in primary (or elementary) school.

Only print the top half triangle of products.

Let's start with the solution:

Step by Step solution about How to resolve the algorithm Multiplication tables step by step in the Excel programming language

Source code in the excel programming language

FNOVERHALFCARTESIANPRODUCT
=LAMBDA(f,
    LAMBDA(n,
        LET(
            ixs, SEQUENCE(n, n, 1, 1),

            REM, "1-based indices.",
            x, 1 + MOD(ixs - 1, n),
            y, 1 + QUOTIENT(ixs - 1, n),
            
            IF(x >= y,
                f(x)(y),
                ""
            )
        )
    )
)


MUL
=LAMBDA(a, LAMBDA(b, a * b))


POW
=LAMBDA(n,
    LAMBDA(e,
        POWER(n, e)
    )
)

You may also check:How to resolve the algorithm Bulls and cows/Player step by step in the Ring programming language
You may also check:How to resolve the algorithm Van Eck sequence step by step in the Fōrmulæ programming language
You may also check:How to resolve the algorithm Regular expressions step by step in the D programming language
You may also check:How to resolve the algorithm Sort three variables step by step in the zkl programming language
You may also check:How to resolve the algorithm Averages/Median step by step in the MiniScript programming language