=if(and(a1=a2,a2=a3),4,0)

or a la Rick:
=4*(AND(A1=A2,A2=A3))

no, I got that wrong:
=4*(A1=A2)*(A3=A3)


--
p45cal

*p45cal*
------------------------------------------------------------------------
p45cal's Profile: http://www.thecodecage.com/forumz/member.php?userid=558
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=146902