Forum Discussion

Ollie1785's avatar
Ollie1785
Copper Contributor
Feb 25, 2020
Solved

'If' statement help needed

What I trying to do may not be possible. I use the statement below to indicate what I want to do rather than being an accurate formula. What I need to to test a cell for a value (first set  of bracke...
excel
  • Savia's avatar
    Savia
    Feb 25, 2020
    In Excel this would read as:

    =IF('Start Sheet'!B5="L", IF('Score Input'!$D$3>='Course Card'!B$11, 1, 0), IF('Score Input'!$D$3>='Course Card'!B$6, 1, 0))
PReagan's avatar
PReagan
Bronze Contributor
Feb 25, 2020

Hello Ollie1785,

 

To attach a workbook, click reply then at the bottom you will see "Drag and drop here or browse files to attach"

Ollie1785's avatar
Ollie1785
Copper Contributor
Feb 26, 2020

PReagan yes thanks I think LOOKUP may well make things a bit easier. I set this file up using my rather rusty Excel skills so its pretty basic I think in structure. File is attached. Thanks for looking at it.

  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Platinum Contributor
    Feb 26, 2020

    Ollie1785 

    Being a golfer myself, I recognise what you are trying to achieve. Based on the Course Card, I believe you made the scoring and points calculation unnecessarily complex and it doesn't seem to be correct either.

     

    I have added a calculation example below the Course Card using the standard formula for points per hole:

    Points = 2 + Strokes received - Strokes Played

     In turn "strokes received" equals:

    If Stroke Index >= Playing Hcp THEN Strokes received = Par+1 ELSE Strokes received = Par

    Since your score card has different Pars and Stroke Indices for Men and Ladies, it becomes a bit more complicated. Hence, the use of INDIRECT and INDEX.

    Perhaps this can inspire you to revise your scoring system.

     

    • Ollie1785's avatar
      Ollie1785
      Copper Contributor
      Mar 31, 2020
      Yes, I think you are right. I have it working now with 'IF' statements, but it is really complex, and may be difficult to come back to in a year or two. But, we cant play golf at the moment anyhow due to the CoronaVirus so I'll put some effort into INDEX and INDIRECT over the coming weeks. Thanks for you input....Much appreciated. Keep well!

Resources