Inserting curly brackets within a formula

R

Romileyrunner1

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
 
S

Shane Devenshire

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

Romileyrunner1

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top