Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
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' ! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Find value in array | Excel Worksheet Functions | |||
Is it possible? | Excel Worksheet Functions | |||
Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
Match then lookup | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions |