Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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? |