Yes zero is the correct answer in this case. However you are asking the
formular to put it in another cell (in this case we will say cell D1),
I can only guess you are trying to say that for example the information
is in C1 and the formular is in D1 and you are saying that if A1 = B1
then put that information in cell D1 if that is the case then yes zero
is correct. The way that I normally would do it is
=if(A1=B1,C1,if(A1=B1,D1,0)). I hope this is of help to you but please
bare in mind I am only new to this bussines of helping other people I
am normally asking other people for help. But I am only to happy help
if I can.

Paul Maynard

Moscow


--
paulrm906
------------------------------------------------------------------------
paulrm906's Profile: http://www.excelforum.com/member.php...o&userid=28776
View this thread: http://www.excelforum.com/showthread...hreadid=500994