I have a formula that is working in one sheet but not another of the same file. I notice the working formula has {} around it, while the one that is not working does not. I cannot add the {}. The is a new problem in a file I have used for years. How can I get the formula to work again? The formula is =MAX(IF($Benefits.$H$4:$Benefits.$H$4953=C3,$Benefits.$B$4:$Benefits.$B$4953))
Please use a short descriptive title and don’t put the details into the title (sample: Meaning of curly brackets in formula, or How to enter curly brackets into formula or something like that)
No idea what prevents the formula to become array formula (except possibly the need to modify the formula at least by adding then removing a space before pressing Ctrl+Shift+Enter) - a sample document could clarify this; but a simple firmula like
=MAXIFS($Benefits.$B$4:$Benefits.$B$4953;$Benefits.$H$4:$Benefits.$H$4953;C3)
could help.
Yes! That formula works. Thank you.
Hi there
The {} brackets indicate an array function. They are added by selecting CTRL+SHIFT+ENTER on the cell.
So in short if you have A = SUM(LEN(A1)+LEN(A2)+LEN(A3) etc), you can replace it with A = {SUM(LEN(A1:A4)}
See https://libreofficehelp.com/count-characters-in-libreoffice-calc-cell/
I have always used CTRL+SHIFT+ENTER with the Formula box checked on all the cells with this formula, but the {} do not appear nor can they be added. It is supposed to return a date from column B, but the date it returns is always 12/30/99.
The {} are not part of the formula but just indicate for display in the Input Line that it is an array formula. To force that on an existing formula, edit the cell (F2) and append and remove a blank to mark the cell as changed and press Shift+Ctrl+Enter.