Forum Discussion
Solved
Shorter way or shortcut to use IF, AND, AND drawing from 3 variables
I have a scoresheet spreadsheet I've developed. I have 12 players playing 5 courses and each course you could be playing FRONT or BACK. Each player has a unique number associated with their name, the...
- I'm very impressed by this formula! I am tooling around with it to expand it to all courses and when the formula is on separate worksheets etc. But you've given me a great tool to work with! Thanks.
Just for the record, the solution that SergeiBaklan gave you is not VBA. It is a function (LET) that is only available in the newest versions of Excel, and it's a powerful one, a way to make formulas more readable and therefore more manageable. Also for the record, building deeply nested IF functions sadly goes in the opposite direction, less manageable and far less easily maintained, more error prone as a result.
Here, to help learn LET and how it works, its value, is a web reference site describing it: https://exceljet.net/excel-functions/excel-let-function
Thanks for that clarification before I disappeared into a VBA rabbit hole! To be clear, a deeply nested IF function is what I am trying to avoid, correct? Quadruple Pawn's formula seems to work pretty well. I just need to now expand it to include all courses and apply across multiple pages of the workbook.
- I have 365 for Mac so it is compatible. Where does the rest of the formula "live"? J3 has "=_xlfn.LET(" in it, but the function works so the rest must be somewhere! I want to play around with expanding this to the full tournament.
tomeegee Nested IF() always works fine and available on any version, except it's bit hard in support.
