Originally Posted by wickedchew

=IF(AND(B2=0,C2=0),0,IF(B2C2,3,IF(B2=C2,2,0)))

NOTE: Your file doesn't show and zeros. To show the zeros (Excel 2007):

Excel Options Advanced Display Options for this worksheet Check "Show a zero in cells that have zero value."