| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
what do { } mean/do?
Brilliant and very fast - you guys are awesome! thanks
"Tim Zych" wrote: They tell Excel to calculate the formula as an array formula but cannot be entered manually. In formula edit mode, press Ctrl + Shift + Enter. That will make the formula an array formula again. -- Tim Zych www.higherdata.com Compare data in workbooks and find differences with Workbook Compare A free, powerful, flexible Excel utility "rob41" wrote in message ... Hi, I am trying to edit a formula in a cell -: {=AVERAGE(IF(Figures!IV$2:IV$698=L163,Figures!M$2: M$698))} As soon as I enter the cell to change, the { } from around the formula disappear. If I enter them manually the formula stops working. Can someone tell me what they are and how I can edit the formula without losing this (what seems like) "formula protection" of some kind? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Hybrid Mode
