excel 2003 If function
 

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

excel 2003 If function
 

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 2003 If function
 

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

excel 2003 If function
 

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

excel 2003 If function
 

"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