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.
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.
tomeegee Nested IF() always works fine and available on any version, except it's bit hard in support.
- 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.