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.
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.