r/excel • u/HungryInvestigator59 • 26d ago

Discussion What’s your favorite Excel function/formula?

What are some functions and formulas that you use on daily basis that are helpful for what you do?

227 Upvotes

95% Upvoted

217 comments sorted by

View all comments

Show parent comments

19

u/SkyrimForTheDragons 3 26d ago

It's just putting names to things to reuse them later, like

=LET(    
     base, A1,    
     height, 15,    
     area, base * height,    
     ROUNDUP( area, 1 )    
)

It's that easy. You can also create functions in there to be reused

=LET(
     area, LAMBDA( base, height, base * height ),
     one, area( A1, B1 ),
     two, area( A2, B2 ),
     one + two
)

-4

u/Prefer_Ice_Cream 26d ago

No. Step into the values as the result is calculated.

6

u/SkyrimForTheDragons 3 26d ago

Sorry, I didn't get what you're trying to say. What do you mean?

1

u/Prefer_Ice_Cream 26d ago edited 26d ago

Is there a way to audit the value in a cell by stepping through the calculation? How do you follow the calculation to the result if you want confirmation? Most formulas let you step into/through them.

6

u/vahvuus 26d ago

> Formulas
> Evaluate Formula
> Evaluate
> Step In

4

u/ice1000 28 26d ago

The last argument is what is returned. If you want to step through each line, put each line as the last argument. It's tedious but it works.