having a cell show a value before input

  • Thread starter Thread starter jfab
  • Start date Start date
J

jfab

i am trying to do a football standings sheet.
it looks like this:
week #1 this is th
update section
col a col b col c col d col e col f col g
col h col i
team score team score team wins losses ties per%
A 7 B 0 A 1 0
0 1.0
C 7 D 0 C 1 0
0 1.0

there are only 4 games a week, but i have input the entire 9 wee
schedule, so that the remainer of the schedule looks like week #1 bu
without any scores. In other words Col's b & d are blank. The proble
develops in the weekly update side, after week #2 and all followin
weeks, concerning the ties.before inputing any scores.
After week #2 it looks like this; col e col f col g col h co
i
A 0
0 1 .500
B 0
0 1 .500
As you can see i have a zero in both the wins and losses columms, bu
NOT the ties columm.I need to remove the 1 in ties and show a zer
before input.My ties formula is this:
=IF(b89=d89,"1",IF(b89>d89,"0",IF(b89<d89,"0")))
the whole thing updates to another part of the sheet which totals al
the wins, losses, etc.The thing is it will work after weekly input, bu
it would show say wins losses ties pec%
2
6 .125
ANY help for this... PLEASE
 
Hi jfab!

If you'd like, I'll take a look at your worksheet. Post a
good (but munged) email address and I'll get in contact
with you.

My address is bogus.

Biff
 
Back
Top