Using LET function with arguments?

[mrblister]

I have a very long formula, that I currently have to repeat with different arguments.

For example, let's say the long formula is: "addDecimalOne(var)", which the formula adds 0.1 to "var".

I want to run that formula with 2 different vars, then sum it up.

Is there a way to use the LET formula (Excel 2021) to shorten that formula?

This is as close as I can get:
"=LET(var,1,addDecimalOne,(var+0.1+N("this simulates super long formula")),addDecimalOneA,addDecimalOne,var,2,addDecimalOneB,addDecimalOne,addDecimalOneA+addDecimalOneB)"

But Excel won't let me run that formula, as the following error appears due to the second "var": "You can't define the same name twice in a LET function."

Any advice? Note I'm using Excel 2021, so I have access to LET but not necessarily newer functions included in Excel 365.

 

[duggie33]

Hi mrblister,

Here is a simple example of using the LET function...

Book1
	A	B
1	a	3
2	b	7
3
4	Let formula	21
Sheet2

Cell Formulas
Range	Formula
B4	B4	=LET(a,$B$1,b,$B$2,IF(a>b,a+b,a*b))

You might be thinking of making a LAMBDA function. They are generally more complex to write, but much more powerful; like creating your own functions.

Hope that helps,

Doug

 

[mrblister]

Thanks for replying Doug. Unfortunately, Excel 2021 doesn't include LAMDA. Is there no way to do what I want with LET?

 

[duggie33]

It can probably be done, but I couldn't follow exactly what you are trying to do...I am getting tired early tonight LOL. Maybe you could provide an example of your inputs with expected output and post it with XL2BB if you have that option. I almost always have to build formulas step-by-step in multiple cells, and them combine them into the LET function.

Doug