Hi,

Am Thu, 25 Apr 2013 16:05:02 +0000 (UTC) schrieb tb:

IF(AND($N4="IT1L",OR($O4={"ACQ","ERM","MOF","MOR", "PRO"},$S40)),($AF$4+
$AG$4+$AH$4)/5*7+$AI$4+$AJ$4,0)

into the formula you have to write the curly brackets.
CTRL+Shift+Enter is to enter an array formula and will set the curly
brackets to the start and the end of the formula.


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2