View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Shane Devenshire[_2_] Shane Devenshire[_2_] is offline
external usenet poster
 
Posts: 3,346
Default 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