this post was submitted on 11 Dec 2023
32 points (79.6% liked)
JavaScript
1700 readers
47 users here now
founded 1 year ago
MODERATORS
you are viewing a single comment's thread
view the rest of the comments
view the rest of the comments
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.
Good news Everyone
Excel has a JS API now, so we can get rid of VBA entirely and fill Excel with terrible ternary operators!
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.