I would be interested in seeing how to combine this into a more complex formula to avoid all the helper columns. I can convert them into a let statement, but it fails at the "sum" operation step.
No doubt it is possible, but not convinced it is desirable. The less complicated the formulas the better I always feel. There is a benefit to coming back to a spreadsheet after a long time and instantly seeing how it works without spending time getting your head around a formula. Not to mention other people being able to pick it up and understand it. I appreciate the skill of lengthy complex formulas but in businesses they can be a bit of a liability in my experience. Happy to hear alternative views on this, as given their popularity on videos I feel I might be missing something 🙂👍 John
Thanks John
Fast in there watching this John. Thanks again 👍John
I would be interested in seeing how to combine this into a more complex formula to avoid all the helper columns. I can convert them into a let statement, but it fails at the "sum" operation step.
No doubt it is possible, but not convinced it is desirable. The less complicated the formulas the better I always feel. There is a benefit to coming back to a spreadsheet after a long time and instantly seeing how it works without spending time getting your head around a formula. Not to mention other people being able to pick it up and understand it. I appreciate the skill of lengthy complex formulas but in businesses they can be a bit of a liability in my experience. Happy to hear alternative views on this, as given their popularity on videos I feel I might be missing something 🙂👍 John