Forum Discussion
EXCEL FORMULA
Hi CURTIS775
I'm not sure that something like this can even be done with a simple formula, because there doesn't seem to be any logic that leads from the par to the points with the player results in the mix.
Your best approach might be to create a lookup table with columns for par, play and points. Enter all the possible combinations for par and play into the first two columns, then enter the points for each of these combinations. Then you can use a lookup formula to look up the combination of par and play and return the results.
Assuming that there will be only unique combinations of Par and Play, the formula could be something like this scenario. The lookup table with Par, Play and Points is in columns A, B and C. I've only entered two rows, you will need to add the other ones.
=SUMIFS(C:C,A:A,E2,B:B,F2)
In the table, will I need to set up for every combination? such as if the score on a par 3 hole is greater than 4 the points will be 0. Could you show me that formula?
Thank you for your help
CURTIS775
I have to do standard deviation, coefficient of variation and medium in excel but dont know how formula is for that? Tell me please. I dont know how to ask by only my post here not to reply? So that why I am writing here.
