How many similar functions can be put in one cell?

  • Thread starter Thread starter Guest
  • Start date Start date
Ron Rosenfeld wrote...
...

Whether Excel's formula parser is the problem is speculation. However,
OpenOffice accepts the OP's original formula (once commas are changed
to semicolons), and gives the intended result. If the file were saved
in XLS format, Excel has no problem opening the file and
using/recalculating the formula as-is. Excel just can't edit it.

So, yes, the OP could install OpenOffice and use it to create deeply
nested formulas, save as XLS, then use (but not edit) in Excel.
Click to expand...

Thanks for refreshing my memory on that point.
--ron
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Editing an "IF" function across a worksheet/excel file 2
Why does this confuse me?? -- ? on Offset function 1
IF function says too many nested 1
want to track time while paste value in multiple column of same roe 1
UDF Function 1
IF AND Nested Functions - Formula Not Working 0
Excel Trying to code an Array Function in VBA Excel to works as a MaxIF 3
Round Function 5

Back
Top