I've chucked an update post here that uses a variation on your suggested approach https://paul-samuels.com/blog/2022/04/27/more-unit-testing-with-excel-lambdas-

I've chucked an update post here that uses a variation on your suggested approach https://paul-samuels.com/blog/2022/04/27/more-unit-testing-with-excel-lambdas-revisited/ https://paul-samuels.com/blog/2022/04/27/more-unit-testing-w... I did it using the same focus as the original post of trying to show the value of getting a formula behind some tests. In the post having this completely different more Excel like approach helps showcase the benefit of tests, where I can completely change the formula and still be confident things work because tests verify it does. Cheers for the formula guidance