If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Nesting a nested function with {..}
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" wrote in message ... 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 Thanks. |
Thread Tools | |
Display Modes | |
|
|