• 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.

How Do I Adjust This Formula...?

BL84

Member
Here's the formula. =IF(H17-A17≥1,CHAR(129),"")
If H17-A17 = 1 thru 9, one dot will appear. (Obviously, it could = 2,3,4 etc.)
If H17-A17 ≥ 10, I need two dots to appear. =IF(H17-A17≥10,
Sadly, I don't know how to add that piece to the formula.

Thanks for any help!

B
 
Here's an example card. H17-A17 = 11. So, hole 12 and hole 16 received an extra dot.

Thanks

B

Double Dot.png
 
Okay, here's what happened. Error popped up for your formula Ali. Highlighted in blue was A17≥10. Of course I don't know why.
Ali, if I copied your formula in error, please correct me. If you can tell why it didn't work, please let me know. I will keep both formulas for future reference. Bosco, your formula solved my issue. Thank you. Below is how I had to change it and it worked perfectly. Golf card. 9 holes.
As always, this forum is very helpful!

BL

Bosco.png


Ali.png
 
Last edited:
Not near a computer at the moment so can't check but I see

and wonder whether it should be
>=
?
 
I switched that around on one cell and it did seem to work.
Good catch!

Thanks--p45cal

BL
 
Yes, it should be:

=IF(H17-A17>=10,REPT(CHAR(129),2),IF(H17-A17>=1,CHAR(129),""))

Sorry - I just assumed you would know the correct way to do this in Excel.
 
Ha! If I knew much about writing formulas...
I do not. I'm such a novice, when I say what would the formula look like, I REALLY mean the ACTUAL formula.
Both formulas work. I have to adapt Bosco's, but it works as well.
I truly do appreciate the help & so do the golfers in my league!
I will likely be back in the future when I need a formula for something else.

Thanks everyone,

BL
 
Back
Top