Prev: Built in Excel 2003 need to convert to 2007
Next: If or formula
From: victorio on 2 Jun 2010 20:45
I have cells that say if value is equal a certain points will be given if a
tie 2 points are given by comparing the score in 2 cells. the problem the
games have not been played and is already showing a tie so everybody is
gotten their 2 points for the tie and 5 point for getting the score correct
blank = blank.

How do i do so the cell when they are blank do not compute
From: "David Biddulph" groups [at] on 2 Jun 2010 22:05
=IF(COUNT(A$1:B$1)<>2,0,IF(AND(A2=A$1,B2=B$1),5,0)+IF(A2=B2,2,0))
--
David Biddulph


"victorio" <victorio(a)discussions.microsoft.com> wrote in message
news:A5EA003B-2329-457D-9A9D-9ACC7A493C67(a)microsoft.com...
> I have cells that say if value is equal a certain points will be given if
> a
> tie 2 points are given by comparing the score in 2 cells. the problem the
> games have not been played and is already showing a tie so everybody is
> gotten their 2 points for the tie and 5 point for getting the score
> correct
> blank = blank.
>
> How do i do so the cell when they are blank do not compute


 | 
Pages: 1
Prev: Built in Excel 2003 need to convert to 2007
Next: If or formula