• jadero@programming.dev
    link
    fedilink
    arrow-up
    3
    arrow-down
    2
    ·
    1 year ago

    Or anywhere for that matter. Have you got nested IF()s in Excel? For crying out loud, pop into VBA and write it up as a custom function like a human being.

      • jadero@programming.dev
        link
        fedilink
        arrow-up
        1
        ·
        11 months ago

        Oh, I didn’t know that Excel could do JS. I haven’t touched it since I got out of the field a decade or so ago.

        One of the things I did was quite a bit of Excel consulting and training. I remember the joy of trying to decode massive formula cells, especially when there were nested IF()s. My rule of thumb was that anything with more than three functions in one formula got converted to a custom function, even if it didn’t have general utility.

        I found that anyone who could construct and understand those massive formulas were generally capable of dealing with the equivalent VBA with a bit of training. Also, it was generally true that if they couldn’t handle the relevant VBA, they were in no position to deal with massive formulas anyway.