Quote:
Originally Posted by gundesvan
I want the column E to show "0" when i havent filled in with any results.
Ofcourse i mean 1 point where i have written 2point. (draw)
|
=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."