| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
what do { } mean/do?
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
what do { } mean/do?
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? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
what do { } mean/do?
{...} signify you have an array formula. It must be committed with
Ctrl-Shift-Enter, rather than just Enter. So, modify the formula as usual, but hit Ctrl-Shift-Enter when you're done. Regards, Fred. "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? |
|
#4
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 | |
|
|
Linear Mode
