• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Help With Excel Formula Needed...(Golf Card)

BL84

Member
Simply put, I need an Excel formula that will replace the Numbers formula. You can see what the Numbers formula does when handicaps are subtracted.
The gray appears due to conditional formatting. The numbers will appear under the "strokes given" heading depending on which handicap is larger. I'm updating
so I can use the formula on both sides of the score card. Formula must be slightly different for Excel. The Numbers sheet has the formula listed.
The handicaps on the Excel sheet are at A17 & H17. If more info is needed, just ask.

Thanks

BL

8406884069
 
I figured it out. ONE parentheses was messing me up. The formula would be: =IF(h17-a17>=5,5,"")
Once I removed the "" from the 5, it all worked out.
Thanks for looking in on me!

BL
 
Back
Top