View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JP Ronse JP Ronse is offline
external usenet poster
 
Posts: 174
Default 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