Curly Brackets
 

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

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)

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.
--
tb

Curly Brackets
 

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

Curly Brackets
 

On 4/25/2013 at 11:08:01 AM Claus Busch wrote:


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!

--
tb