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

BL84

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

Thanks

B

AliGW

Active Member
=IF(H17-A17≥10,REPT(CHAR(129),2),IF(H17-A17≥1,CHAR(129),""))

bosco_yip

Excel Ninja
Or,

=REPT(CHAR(149),(H17-A17>9)+(H17>0))

BL84

Member
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

Last edited:

p45cal

Well-Known Member
Not near a computer at the moment so can't check but I see

and wonder whether it should be
>=
?

BL84

Member
I switched that around on one cell and it did seem to work.
Good catch!

Thanks--p45cal

BL

AliGW

Active Member
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.

BL84

Member
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