Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Inserting curly brackets within a formula

3,281 views
Skip to first unread message

Romileyrunner1

unread,
Aug 26, 2009, 3:09:01 PM8/26/09
to
Hi,
anyone know which key strokes are needed to insert curly brackets within a
formula:

EG:
=(AVERAGE(IF(($H$10:$H$89=0)*($N$10:$N$89={"W","SA","SA+","ST"})*($AJ$10:$AJ$89>-10),$AJ$10:$AJ$89)))

Thanks
RR1

Teethless mama

unread,
Aug 26, 2009, 3:27:02 PM8/26/09
to
ctrl+shift+enter

Shane Devenshire

unread,
Aug 26, 2009, 3:30:08 PM8/26/09
to
Hi,

{}'s are the shifted keys to the right of th P key. that's what you need to
insert the brackets "inside" the formula. Outside the formula you do not
type them you press Shift+Ctrl+Enter instead of Enter.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire

JP Ronse

unread,
Aug 26, 2009, 3:31:59 PM8/26/09
to
Try ...

<control><shift><enter> to enter as an array function.

Wkr,

JP
"Romileyrunner1" <Romiley...@discussions.microsoft.com> wrote in message
news:9F7CAD5F-E4A6-4B27...@microsoft.com...

Romileyrunner1

unread,
Aug 26, 2009, 3:59:02 PM8/26/09
to
Blimey, I`ve been staring at this keyboard for ages and never noticed them:
what a ninny I am!
Thanks, that`s a great help.
RR1
0 new messages