View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
rob41 rob41 is offline
external usenet poster
 
Posts: 2
Default 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?