If(Or) Statements Question

[owned4u]

This is going to be hard to explain and may not be very easy to understand if you don't understand how "best ball" scoring in golf works, but I'll try my best and post some pictures also.

I have 4 players who will have scores that are relative to the "par" row. The lowest score out of all of the players is counted (ie. Par = 4, two players have a 4, one player has a 5, and one player has a 3. The 3 is the lowest score and is thus "-1")

I want a given cell to give me a result of "-1" if the best score is one less than par, "0" if the best score is equal to par, and +1 if the best score is par plus 1.

I started by trying just an IF statement, but I think I'm going to need to use an IF(OR) statement.

I'm not sure if my syntax is wrong or if I'm just using the IF statement wrong or what, but I'd appreciate any help. screenshot.jpg

[FDibbins]

Hi, welcome to the forum

Instead of a picture, upload a sample workbook, we cant edit pics

Having said that, take a look at using something like this...
=min(B2:E2)-par where par is the cell with your hole par in it

[alansidman]

In C8 type =MIN(C4:C7)-C3
and copy to the right.

[owned4u]

Wow that was so much simpler than I made it out to be. Thank for the quick replies so much!

[alansidman]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.