"Stan Halls" wrote in message
...
I have a spread sheet in excel 2003 that has formular in it that add
various
cell values to gether and when i use the If function to test the cells i
keep
getting wrong results
=IF(AC30,1,0) every result = 1 even though the value in the cell is zero
AC3 contains
=IF((C3+E3+G3+I3+K3+M3+O3+Q3+S3+U3+W3+Y3)0,(C3+E3 +G3+I3+K3+M3+O3+Q3+S3+U3+W3+Y3)/AT3,"")
can anyone tell me what i am doing wrong as i am new to excel and used to
lotus 123

=IF(N(AC3),1,0)

Bruno