what do these brackets around a formula mean {formula} ?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

{=+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' !
 
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)
 
Back
Top