What does it produce for you?
On my Excel 2002 it produces 1 when the three cells are zero(0) or blank.
Gord Dibben Excel MVP
On Mon, 29 Nov 2004 12:21:02 -0800, "soxn4n04"
wrote:
I've tried the following formula to get a score of 1 if zero is entered in
cells 31, 32, 33. This formula does not produce the correct results. Help!!
=IF(AND(C31=0,C32=0,C33=0),1,"")
|