View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 1,726
Default what do these brackets around a formula mean {formula} ?

It means that it is an array formula, a formula that works on an array
(range) of cells.

The braces are inserted by Excel if, after typing the formula, you commit it
with Ctrl-Shift-Enter rather than just Enter, you do not type them. When
updating the formula, it should again be array-entered.

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"Fruitaz" wrote in message
...
{=+SUM(IF($F$3:$F$83=$A87;$AD$3:$AD$83;0))*B87/1.25}
those brackets disappear automaticly once i click the formula bar
if i copy formula without those brackets the return is '#value' !