Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Inserting curly brackets within a formula
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Inserting curly brackets within a formula
ctrl+shift+enter
"Romileyrunner1" wrote: 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Inserting curly brackets within a formula
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 "Romileyrunner1" wrote: 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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Inserting curly brackets within a formula
Try ...
<control<shift<enter to enter as an array function. Wkr, JP "Romileyrunner1" wrote in message ... 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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Inserting curly brackets within a formula
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 "Shane Devenshire" wrote: 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 "Romileyrunner1" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
what do the brackets { } mean around a formula? | Excel Worksheet Functions | |||
Formula is surrounded by brackets | Excel Discussion (Misc queries) | |||
Getting rid of curly brackets within formula | Excel Worksheet Functions | |||
Getting rid of curly brackets within formula | Excel Worksheet Functions | |||
Getting rid of curly brackets within formula | Excel Worksheet Functions |