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(AC30,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,"")


--
Bearacade


------------------------------------------------------------------------
Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016
View this thread: http://www.excelforum.com/showthread...hreadid=552418

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

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

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

HTH,
Elkar


"Stan Halls" wrote:

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

Thank you for your help, it works fine now

"Elkar" wrote:

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

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

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

HTH,
Elkar


"Stan Halls" wrote:

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

"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