Forum Discussion
Solved
Help with an If/And formula
Hi, I've been trying to get a formula to work for a while to no avail and I'm hoping someone here can help. I'd be very grateful for any tips as I feel like I have complete tunnel vision at this poin...
This is very helpful too, it's interesting to see different ways of doing it and I wasn't familiar with the Let function but it will definitely come in handy when writing longer formulas - thank you!
it's interesting to see different ways of doing it
One of the more interesting/fascinating aspects of Excel is that there are OFTEN multiple ways to get from A to B. In this instance, HansVogelaar definitely gave you the more elegant, efficient way; I was caught up in the "fun" of using LET, and working down in the weeds, I missed the simpler solution.
The LET function is new, as I said, and can be used in a lot of ways. If you are able to use it, and are interested in learning more, you might also be interested in LAMBDA, which enables you to write what are in essence user-defined functions (for use throughout the workbook in which you define them).