Author: compjinx
-
Advanced Sheet Formulas: Expresso 2000 Expression Parser, a Progress Snapshot
In this post, I am going to dive into a recent project that I’ve been working on: a google sheet cell formula that will evaluate text math expressions. Did that make sense? Lets try an example. We can all solve math expressions in Google Sheets and Excel, right? Just type an ‘=’, some expression, and…
-
Unlocking the Power of LAMBDA Functions in Google Sheets and Excel
Introduction LAMBDA functions, now supported in both Google Sheets and Excel, are a game-changer. As someone who loves programming as a hobby and has used it to extend the usefulness of spreadsheet software, I’ve always been frustrated by the limitations and drawbacks of scripting in these two ubiquitous applications. But with the introduction of LAMBDA…
-
First Comment
This is the first “blog” post. I’ll probably get around to deleting it in a few years.