Forum Discussion

GeorgieAnne's avatar
GeorgieAnne
Iron Contributor
Sep 20, 2025

I need to learn how to use the LET function in Excel...

Hello Excellers,

I am using a complex If statement to figure out if a machine is ready to receive work.

I need to check if the machine is online, or broken down, or off line for some reason or another, Has a Human worker to work on the machine, and on and on...

I am thinking would a LET function help in making the IF function more accurate, and less complicated?

I have not worked with the LET function, and I think I would like to learn about it. Any nice resources for examples and tutorials?

Thanks in Advance!

GiGi!

 

community
developer
excel
Formulas and Functions
Macros and VBA

1 Reply

  • mathetes's avatar
    mathetes
    Silver Contributor
    Sep 20, 2025

    Sounds as if the IFS function (notice the added "S") might be more suitable than plain ol' IF.  I don't see why LET would fit -- what makes you think that? LET is very powerful and useful where it fits, but nothing in your description shouts "Let" to my ears. In any event, those two hyperlinks connect you to one of the best resources for researching any Excel functions.

Resources