Forum Discussion
Curly brackets added to formulas once workbook is copied and emailed out
[SOLVED] Hi all, I'm having an issue where my formulas change after the workbook is opened on other PCs. For example, here's how a formula appears in my workbook, where I calculate with just the ...
It looks like your version of Excel supports dynamic arrays, and on another PC is pre-DA version of Excel.
Wrap your formula with @ like
=@IFS(AND(...))with that on pre-DA Excel it'll be opened as regular one (non-array formula).
It looks like your version of Excel supports dynamic arrays, and on another PC is pre-DA version of Excel.
Wrap your formula with @ like
=@IFS(AND(...))with that on pre-DA Excel it'll be opened as regular one (non-array formula).
