=IF(or(and(I2=500,S2=15,N2="CPSTART"),N2="CPRESU M"),1,0)

HTH,
--
Gary Brown

If this post was helpful, please click the ''Yes'' button next to ''Was this
Post Helpfull to you?''.


"Alma" wrote:


What is wrong with this formula:

=IF((I2=500)*AND(S2=15)*AND(N2="CPSTART")*OR(N2= "CPRESUM"),1,0)

THANKS:)


--
Alma
------------------------------------------------------------------------
Alma's Profile: http://www.excelforum.com/member.php...o&userid=19335
View this thread: http://www.excelforum.com/showthread...hreadid=506849