Sep 28 2024 09:34 AM - edited Sep 28 2024 09:35 AM
Hello,
For the longest time, I had been looking for an excel add-on that would convert a formula in a cell to readable math. I could not can't find one and with some help wrote a basic one here, but it does not work very well on some formulas.
https://github.com/keshishianv/XL-Formula-to-Math
Does anyone know of an add-on that will do so? It makes finding errors super easy.
Thank You.
Sep 28 2024 11:36 AM - edited Sep 28 2024 11:37 AM
I'm curious what has motivated you to be on this search. I know for myself, and I suspect many others, the vast majority of my Excel formulas are not primarily mathematical; rather they involve tables, arrays, matrices, and the retrieving of data from same. Yes, of course, there are SUMs and AVERAGEs and MINs and MAXs and so forth. But those are almost incidental,
As I said, just curious what the contexts are in which such a capability will prove (has proven) to be valuable.
Sep 28 2024 12:32 PM - edited Sep 28 2024 12:32 PM
Hi,
I use it for engineering formulas and some are a bit convoluted. Seeing the math, makes it super easy to verify or fix any errors.
An example:
Sep 28 2024 03:55 PM