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