Curly Brackets

[tb]

I have this snippet of code as part of a larger formula:

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

I cannot remember how I was able to insert the curly brackets in the OR
formula above...

It does not work for me when I do CTR+SHIFT+ENTER or when I simply use
the "{" and "}" symbols and press ENTER.

 

[Claus Busch]

Hi,

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

IF(AND($N4="IT1L",OR($O4={"ACQ","ERM","MOF","MOR","PRO"},$S4>0)),($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

 

[tb]

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

Thanks, Claus!