May 11 2023 06:59 AM - edited May 11 2023 07:01 AM
I'm a very basic user of excel so please forgive my ignorance. I'm attempting to assign a cell a specific value base on certain conditions of another cells value. I'm inputing score cards for my golf league. Each hole they play they will end with a score. Base on whatever they scored they get points for it or get points taken away. Example: If they make a bogey on the hole they recieve 1pt, Par 2pts, Birdie 3pts, Eagle 5pts, and then double Bogey -1pt, Triple Bogey -2pts. So I would have multiple Conditions for each hole. And the conditions wont always be the same because each hole is different in terms of PAR. I ignorantly tried to just create one condition to see if I could. Mine looked like this =2IFC39=4. meaning 2 pts because they parred the first hole (first hole is a par 4). If someone could help with how this formula should actually look it would be help me so much. And beyond that, If this is even possible
May 11 2023 07:23 AM - edited May 11 2023 07:24 AM
Given multiple holes, differing pars, etc., you'd probably be better served by approaching this with a couple of tables and using one of several different LOOKUP formulas. By tables, I mean something like this:
To paraphrase your first sentence, though, describing myself "I'm not at all experienced in golf, neither player nor spectator, so please forgive my ignorance." I do know Excel, I think, sufficiently to answer your Excel questions once you clarify such things as:
And, yes, I really am that ignorant about golf. (Tennis is my game.)
I also am part of a small group of friends who play several of the word games that have become so popular in recent months, and I have a spreadsheet where I tabulate the results. Each day's results, results YTD, and averages, medians, etc. The top level summary looks like this (and just like golf, the low score wins; OK, I'm not totally ignorant of golf's rules).
May 11 2023 07:24 AM
Hi @mdmiles1485
you are already very close with your formula.
=IF(C39=4;2;0)
It gives 2 if the value in cell C39 = 4, otherwise it gives 0
May 11 2023 07:40 AM
=VLOOKUP(C2-B2,$G$2:$I$7,3,FALSE)
=VLOOKUP(C2-B2,$G$2:$I$7,2,FALSE)
An alternative could be a reference table along with VLOOKUP formulas. The formulas are in cells D2 and E2 and filled down.