How to make cells blank

[Kernow Jon]

Hi Everyone, I am a bit of a self-taut amateur and have been using Excel to run a league of eight individual DART players. Everything has been going quite well.....But I have now hit a problem I just can’t seem to find an answer for, so would really appreciate it if someone could tell me if what I want to do is actually possible?

I am taking information off weekly result sheets of the match scores. Each match is 8 legs so a draw will be a 4-4 score line. The zeros in G10 and H10 is causing other formulas to give won draw lost returns before required so I need these cells to be BLANK.

Can I achieve this with conditional formatting? Or can I somehow rewrite the line in G10 to keep the cells BLANK until the actual match score is entered in my weekly sheets? Pulling my hair out trying to work out something which I suspect is quite simple to you guys out there. Any help, ideas or a solution would be greatly appreciated.

I have entered results from week 1and 2 which then brings the other formulas on this Players sheet into play.

The formula I have put in F10 -F21 is........ =IF(G12=H12,"Draw",IF(G12>H12,"Won","Lost")) I10 - I23 is...... =IF(ISBLANK(G10),0,IF(F10="Won",2,IF(F10="Draw",1,IF(F10="Lost",0,""))))

 

[Kernow Jon]

 

[Fluff]

How about

=if(or(G10="",H10=""),"",if(G10=H10,"Draw",if(G10>H10,"Won","Lost")))

 

[Kernow Jon]

How about

=if(or(G10="",H10=""),"",if(G10=H10,"Draw",if(G10>H10,"Won","Lost")))

A BIG THANK YOU Fluff..... your help has sorted out all the problems I couldn't seem to get my head around, MUCH APPRECIATED. Good Luck to England on their trip to Ireland on the 20th.

 

[Fluff]

You're welcome & thanks for the feedback.