S.I/Lisp/

CELLNAME




=CELLNAME(A1)
-> "A1"

=CELLNAME(A1, YES)
-> "$A$1"
        



DEFINE(
    CELLNAME,
    LAMBDA(
        [reference],
        [absolute?],
        LET(
            address,
                IFOMITTED(
                    reference,
                    CELL("address"),
                    CELL(
                        "address",
                        reference)),
            display_absolute,
                DEFAULT(
                    absolute?,
                    NO),
            IF(
                display_absolute,
                address,
                SUBSTITUTE(
                    address,
                    "$",
                    "")))))
        



Help us optimize this function