Wondering how to leave a cell blank until i finish the formula...

**grrr:)** · 02-05-2013, 07:46 PM

Hello,

I am currently keeping score for an archery league in my home town. Since the sheets were provided to me by the club committy i cannot alter them. So here it goes...
I need help with my formula. so far i have =sum((300- CELL WITH SCORE)*0.85,(+CELL WITH SCORE)) .... TO better explain we shoot a score out of 300 with an 85% handicap on remainding amount we dont shoot. the only problem with this is the cells that i have not imput a score into shows up 255 anyway i can make it stay blank until i place in the next week scores.

example.... i shot a 250
the handicap would be 50 x 85% which is 42.5 or 43
so my total score with handicap is 293

**martindwilson** · 02-05-2013, 07:53 PM

use
=IF(C3="","",SUM((300-C3)*0.85,C3))

**Moo the Dog** · 02-05-2013, 07:56 PM

Put this in cell C5 and fill right:
=IF(C3="","",SUM((300-C3)*0.85,(+C3)))

And this can be used in N2 to hide the #DIV/0 errors when no scores are entered yet:
=IF(COUNT(C3:L3),AVERAGE(C3:L3),"")

- Moo

* martin is a quick one...