Nesting a nested function with {..}

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do brackets nesting a formula affect the formula?

Working on someonelese's spreadsheet found a nested series of IF statements that start and end with brackets {...}. The formula works fine as long I don't touch it. If I try to edit it, the brackets disappear and the formula no longer works. How do I edit such formula and restore the brackets that apparently make it work.

Will appreciate help. Please reply to (e-mail address removed)

Thanks.
 
That is an array-entered formula. Press CTRL-shift-enter when you are done
editing it, and if your edits didn't screw it up, it'll still work :)


Mico Llanos said:
How do brackets nesting a formula affect the formula?

Working on someonelese's spreadsheet found a nested series of IF
Click to expand...
statements that start and end with brackets {...}. The formula works fine
as long I don't touch it. If I try to edit it, the brackets disappear and
the formula no longer works. How do I edit such formula and restore the
brackets that apparently make it work.
 
Back
Top