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' !
|