Excel 2007 : How do i write a if calculation not to count two cells with zero as a default

I have a sheet that calculates bowling scores over 8 games. When the games start all the scores are zero by default. My If statement calculates a two cells with zero as true and awards 1 point as a draw. =IF(I6>0,2,IF(I6=0,1,IF(I6<0,0,)))
i want the if statement in E5 to disregard awarding 1 point as a draw if both A5 and B5 are 0. or blank. Show zero is turned on, as some games may have a result such as 0 - 15

Thanks for the help, but i think i have made a mistake in my explanation.
Cell f5, = IF(A5>B5,"W",IF(A5<B5,"L", IF(A5=B5,"D")))
i require this to ignore the (A5=B5) if Cells A5 and A6 are both zero

in a game, the score could be like this 10-0
To show the zero in the for or against cells i had to activate the show zero in cells option. This means by default the Calculation i used read the blank cells as a zero
i have put in your suggestions an d it is working ok now.
Many Thanks

Thanks this works as well,

Originally Posted by Fotis1991

Hi

In F5, try this.

=IF(A5>B5;"W";IF(A5<B5;"L";IF(AND(A5=0;A6=0);"";IF(A5=B5;"D"))))

Hope to helps you.

It should have been A5 - A 6 my typo.
But its all working, i modified the cell indicator
Regards

Originally Posted by TMShucks

No, I'm asking why you said:



A6 is in the row below A5 so why would you be checking a score on one row against the score on the next row.

Fotis has rightly provided a solution that matches your question/request and which you have said .

I'm just trying to understand why you want this, what it does, and how you have tested it. Do all the rows have zeroes in them at the moment? In which case, it is quite likely that it does work but for the wrong reason.

Anyway, if you are happy with the solutions that you have been given, that's fine.

Thanks for the rep, regards, TMS