You need to do it like this:
=if(and(condition1,condition2),then,else)
/Møller
--
c991257
------------------------------------------------------------------------
c991257's Profile:
http://www.excelforum.com/member.php...o&userid=36549
View this thread:
http://www.excelforum.com/showthread...hreadid=568085