excel 2003 If function

[Stan Halls]

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(AC3>0,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

 

[Bearacade]

IF(AC3>0,1,0) means you are testing if AC3 is greater than 0, if you
want it to include 0, you should put IF(AC3>=0,1,0)

Are you testing for a 0 value? or a BLACK value? you might want to try
this IF(ISBLANK(AC3),1,0)

You are missing a bracelet and have an extra space, correct syntax is:

=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,"")

 

[Elkar]

Excel evaluates "" as greater than 0. Thus cell AC3 will always be greater
than 0 (unless AT3 is negative). Try this instead.

=IF(AND(AC3>0,AC3<>""),1,0)

This tests to see if AC3 is greater than 0 AND not equal to "".

HTH,
Elkar

 

[Stan Halls]

Thank you for your help, it works fine now

Excel evaluates "" as greater than 0. Thus cell AC3 will always be greater
than 0 (unless AT3 is negative). Try this instead.

=IF(AND(AC3>0,AC3<>""),1,0)

This tests to see if AC3 is greater than 0 AND not equal to "".

HTH,
Elkar

 

[Bruno Campanini]

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(AC3>0,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