@ in the beginning of a formulaDynamic Arrays for earlier Excel versionsExcel: Is it possible to have rows...

Least cost swapping in C++

Solving pricing problem heuristically in column generation algorithm for VRP

What modifiers are added to the attack and damage rolls of this unique longbow from Waterdeep: Dragon Heist?

How can I find an old paper when the usual methods fail?

What is the hottest thing in the universe?

Can anybody tell me who this Pokemon is?

Is the Microsoft recommendation to use C# properties applicable to game development?

If a person claims to know anything could it be disproven by saying 'prove that we are not in a simulation'?

Is there any official ruling on how characters go from 0th to 1st level in a class?

Why do so many people play out of turn on the last lead?

What is the opposite of "hunger level"?

Will using a resistor in series with a LED to control its voltage increase the total energy expenditure?

Help, I cannot decide when to start the story

Are there really no countries that protect Freedom of Speech as the United States does?

Why does this Jet Provost strikemaster have a textured leading edge?

A+ rating still unsecure by Google Chrome's opinion

The oceans and the moon

List, map function based on a condition

Is Thieves' Cant a language?

How can I communicate my issues with a potential date's pushy behavior?

Are there any cons in using rounded corners for bar graphs?

Graphs for which a calculus student can reasonably compute the arclength

"Mouth-breathing" as slang for stupidity

Why do my bicycle brakes get worse and feel more 'squishy" over time?



@ in the beginning of a formula


Dynamic Arrays for earlier Excel versionsExcel: Is it possible to have rows with sub-totals that doesn't ruin the total-total?How do I copy a worksheet without creating local copies of workbook-scoped named formulas?import formula from corrupt / large excel workbookExcel Formula to deduct the amount of a textAlign rows from different columns (which contain some cells that have identical values) using simple formula in ExcelWhen should SUM() be used as an array formula vs. not in ExcelSearch in formulas in ExcelExcel, Copy sheet with formulas to new workbook, replace existing referenceexcel clear sets format as accounting






.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ margin-bottom:0;
}







6















I have seen @ in the beginning of some formulas in a workbook, for example: =@SUM(A1:A10), =@VLOOKUP(3;F9:H12;2;FALSE).



It seems that it is a new feature of Excel.



Does anyone know what this @ means?










share|improve this question































    6















    I have seen @ in the beginning of some formulas in a workbook, for example: =@SUM(A1:A10), =@VLOOKUP(3;F9:H12;2;FALSE).



    It seems that it is a new feature of Excel.



    Does anyone know what this @ means?










    share|improve this question



























      6












      6








      6


      2






      I have seen @ in the beginning of some formulas in a workbook, for example: =@SUM(A1:A10), =@VLOOKUP(3;F9:H12;2;FALSE).



      It seems that it is a new feature of Excel.



      Does anyone know what this @ means?










      share|improve this question














      I have seen @ in the beginning of some formulas in a workbook, for example: =@SUM(A1:A10), =@VLOOKUP(3;F9:H12;2;FALSE).



      It seems that it is a new feature of Excel.



      Does anyone know what this @ means?







      microsoft-excel






      share|improve this question













      share|improve this question











      share|improve this question




      share|improve this question










      asked yesterday









      SoftTimurSoftTimur

      3403 gold badges5 silver badges16 bronze badges




      3403 gold badges5 silver badges16 bronze badges

























          4 Answers
          4






          active

          oldest

          votes


















          7














          In Excel 365 builds that already have the new Dynamic Array formulas, all formulas are treated as array formulas by default. The @ sign is used to prevent the new default array behavior of a function if it is not wanted in that particular formula.



          If the same workbook is opened in a non DA version of Excel, it will not be visible.



          If the @ sign is entered into non DA versions of Excel, it will silently be removed when the formula is confirmed into the cell.



          Edit: The @ sign as a prefix to an Excel function should not be confused with the @ sign for Lotus compatibility. These are two different things.



          Consider the following screenshot:



          enter image description here



          It was taken in Excel with Dynamic Arrays enabled. The formula in B2 is =ROW(1:4) and it has simply been confirmed with Enter. The formula is treated like an array formula and the results automatically "spill" into the next rows.



          If this behaviour is not wanted, the function can be preceded with an @ sign and then it will behave like a non-array formula in the old Excel without Dynamic Arrays. In old Excel, I would have to select 4 cells, type the formula and confirm with Ctrl-Shift-Enter to get the formula to return the values into four cells.






          share|improve this answer




























          • Your reply seems better

            – Bella
            yesterday



















          4














          @ sign is popularly knows as Implicit intersection operator to support Dynamic Array formula method. It can be found in Excel 2019 & 365.



          @ sign is almost identical to the older spreadsheet versions, except it uses @ to indicate where implicit intersection may be used, where older spreadsheet versions did this silently.



          Implicit intersection follows these rules:




          • If cell value is a single item, then return the item.


          • If values are in a range, then return the cell on the same row or column as the formula.


          • If it is an array, then pick the top-left value.



          Considering versions like 2013 & 2016, @ can be found with TABLE.



          enter image description here




          • Uses the Column header to carry values in the Row.

          • Consider the example below. If the formula begins with @, it doesn't return an error but removes the @sign as soon as it finishes with Enter, and gets the value 100.


          =@VLOOKUP(G112,A111:E111,2,FALSE)



          enter image description here



          N.B.



          With an older version of Excel, functions that return multi-cell ranges or an array will be prefixed with @.






          share|improve this answer



































            1














            '@' was the way you indicated the start of a formula in program Lotus. Then, Excel allowed for similar usage in addition to using "=", However,Excel automatically change '@' to '='.
            For more details:
            https://www.quora.com/What-does-the-symbol-do-in-Excel-It-keeps-showing-up-as-why-is-this-happening






            share|improve this answer


























            • This applies only to versions of Excel that don't have Dynamic Arrays. The new Dynamic Arrays have a different usage of the @ sign. See my answer for updates.

              – teylyn
              yesterday



















            0














            I agree with AbdelAziz AbdelLatef.



            I tested the "@" symbol in Excel, and I find Excel will immediately change to the equal sign. It seems that "@" is covered by "="



            enter image description here



            So this may not be a new feature of Excel. As far as I know, Recently the new functions are released by Excel is only available to Office Insiders at this time. You can review this in the link:
            https://blog-insider.office.com/2019/06/13/dynamic-arrays-and-new-functions-in-excel/






            share|improve this answer





















            • 1





              This is because you don't have an Excel version with Dynamic Arrays. I updated my answer with some more detail.

              – teylyn
              yesterday














            Your Answer








            StackExchange.ready(function() {
            var channelOptions = {
            tags: "".split(" "),
            id: "3"
            };
            initTagRenderer("".split(" "), "".split(" "), channelOptions);

            StackExchange.using("externalEditor", function() {
            // Have to fire editor after snippets, if snippets enabled
            if (StackExchange.settings.snippets.snippetsEnabled) {
            StackExchange.using("snippets", function() {
            createEditor();
            });
            }
            else {
            createEditor();
            }
            });

            function createEditor() {
            StackExchange.prepareEditor({
            heartbeatType: 'answer',
            autoActivateHeartbeat: false,
            convertImagesToLinks: true,
            noModals: true,
            showLowRepImageUploadWarning: true,
            reputationToPostImages: 10,
            bindNavPrevention: true,
            postfix: "",
            imageUploader: {
            brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
            contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
            allowUrls: true
            },
            onDemand: true,
            discardSelector: ".discard-answer"
            ,immediatelyShowMarkdownHelp:true
            });


            }
            });














            draft saved

            draft discarded


















            StackExchange.ready(
            function () {
            StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1471013%2fin-the-beginning-of-a-formula%23new-answer', 'question_page');
            }
            );

            Post as a guest















            Required, but never shown

























            4 Answers
            4






            active

            oldest

            votes








            4 Answers
            4






            active

            oldest

            votes









            active

            oldest

            votes






            active

            oldest

            votes









            7














            In Excel 365 builds that already have the new Dynamic Array formulas, all formulas are treated as array formulas by default. The @ sign is used to prevent the new default array behavior of a function if it is not wanted in that particular formula.



            If the same workbook is opened in a non DA version of Excel, it will not be visible.



            If the @ sign is entered into non DA versions of Excel, it will silently be removed when the formula is confirmed into the cell.



            Edit: The @ sign as a prefix to an Excel function should not be confused with the @ sign for Lotus compatibility. These are two different things.



            Consider the following screenshot:



            enter image description here



            It was taken in Excel with Dynamic Arrays enabled. The formula in B2 is =ROW(1:4) and it has simply been confirmed with Enter. The formula is treated like an array formula and the results automatically "spill" into the next rows.



            If this behaviour is not wanted, the function can be preceded with an @ sign and then it will behave like a non-array formula in the old Excel without Dynamic Arrays. In old Excel, I would have to select 4 cells, type the formula and confirm with Ctrl-Shift-Enter to get the formula to return the values into four cells.






            share|improve this answer




























            • Your reply seems better

              – Bella
              yesterday
















            7














            In Excel 365 builds that already have the new Dynamic Array formulas, all formulas are treated as array formulas by default. The @ sign is used to prevent the new default array behavior of a function if it is not wanted in that particular formula.



            If the same workbook is opened in a non DA version of Excel, it will not be visible.



            If the @ sign is entered into non DA versions of Excel, it will silently be removed when the formula is confirmed into the cell.



            Edit: The @ sign as a prefix to an Excel function should not be confused with the @ sign for Lotus compatibility. These are two different things.



            Consider the following screenshot:



            enter image description here



            It was taken in Excel with Dynamic Arrays enabled. The formula in B2 is =ROW(1:4) and it has simply been confirmed with Enter. The formula is treated like an array formula and the results automatically "spill" into the next rows.



            If this behaviour is not wanted, the function can be preceded with an @ sign and then it will behave like a non-array formula in the old Excel without Dynamic Arrays. In old Excel, I would have to select 4 cells, type the formula and confirm with Ctrl-Shift-Enter to get the formula to return the values into four cells.






            share|improve this answer




























            • Your reply seems better

              – Bella
              yesterday














            7












            7








            7







            In Excel 365 builds that already have the new Dynamic Array formulas, all formulas are treated as array formulas by default. The @ sign is used to prevent the new default array behavior of a function if it is not wanted in that particular formula.



            If the same workbook is opened in a non DA version of Excel, it will not be visible.



            If the @ sign is entered into non DA versions of Excel, it will silently be removed when the formula is confirmed into the cell.



            Edit: The @ sign as a prefix to an Excel function should not be confused with the @ sign for Lotus compatibility. These are two different things.



            Consider the following screenshot:



            enter image description here



            It was taken in Excel with Dynamic Arrays enabled. The formula in B2 is =ROW(1:4) and it has simply been confirmed with Enter. The formula is treated like an array formula and the results automatically "spill" into the next rows.



            If this behaviour is not wanted, the function can be preceded with an @ sign and then it will behave like a non-array formula in the old Excel without Dynamic Arrays. In old Excel, I would have to select 4 cells, type the formula and confirm with Ctrl-Shift-Enter to get the formula to return the values into four cells.






            share|improve this answer















            In Excel 365 builds that already have the new Dynamic Array formulas, all formulas are treated as array formulas by default. The @ sign is used to prevent the new default array behavior of a function if it is not wanted in that particular formula.



            If the same workbook is opened in a non DA version of Excel, it will not be visible.



            If the @ sign is entered into non DA versions of Excel, it will silently be removed when the formula is confirmed into the cell.



            Edit: The @ sign as a prefix to an Excel function should not be confused with the @ sign for Lotus compatibility. These are two different things.



            Consider the following screenshot:



            enter image description here



            It was taken in Excel with Dynamic Arrays enabled. The formula in B2 is =ROW(1:4) and it has simply been confirmed with Enter. The formula is treated like an array formula and the results automatically "spill" into the next rows.



            If this behaviour is not wanted, the function can be preceded with an @ sign and then it will behave like a non-array formula in the old Excel without Dynamic Arrays. In old Excel, I would have to select 4 cells, type the formula and confirm with Ctrl-Shift-Enter to get the formula to return the values into four cells.







            share|improve this answer














            share|improve this answer



            share|improve this answer








            edited yesterday

























            answered yesterday









            teylynteylyn

            18.4k2 gold badges26 silver badges41 bronze badges




            18.4k2 gold badges26 silver badges41 bronze badges
















            • Your reply seems better

              – Bella
              yesterday



















            • Your reply seems better

              – Bella
              yesterday

















            Your reply seems better

            – Bella
            yesterday





            Your reply seems better

            – Bella
            yesterday













            4














            @ sign is popularly knows as Implicit intersection operator to support Dynamic Array formula method. It can be found in Excel 2019 & 365.



            @ sign is almost identical to the older spreadsheet versions, except it uses @ to indicate where implicit intersection may be used, where older spreadsheet versions did this silently.



            Implicit intersection follows these rules:




            • If cell value is a single item, then return the item.


            • If values are in a range, then return the cell on the same row or column as the formula.


            • If it is an array, then pick the top-left value.



            Considering versions like 2013 & 2016, @ can be found with TABLE.



            enter image description here




            • Uses the Column header to carry values in the Row.

            • Consider the example below. If the formula begins with @, it doesn't return an error but removes the @sign as soon as it finishes with Enter, and gets the value 100.


            =@VLOOKUP(G112,A111:E111,2,FALSE)



            enter image description here



            N.B.



            With an older version of Excel, functions that return multi-cell ranges or an array will be prefixed with @.






            share|improve this answer
































              4














              @ sign is popularly knows as Implicit intersection operator to support Dynamic Array formula method. It can be found in Excel 2019 & 365.



              @ sign is almost identical to the older spreadsheet versions, except it uses @ to indicate where implicit intersection may be used, where older spreadsheet versions did this silently.



              Implicit intersection follows these rules:




              • If cell value is a single item, then return the item.


              • If values are in a range, then return the cell on the same row or column as the formula.


              • If it is an array, then pick the top-left value.



              Considering versions like 2013 & 2016, @ can be found with TABLE.



              enter image description here




              • Uses the Column header to carry values in the Row.

              • Consider the example below. If the formula begins with @, it doesn't return an error but removes the @sign as soon as it finishes with Enter, and gets the value 100.


              =@VLOOKUP(G112,A111:E111,2,FALSE)



              enter image description here



              N.B.



              With an older version of Excel, functions that return multi-cell ranges or an array will be prefixed with @.






              share|improve this answer






























                4












                4








                4







                @ sign is popularly knows as Implicit intersection operator to support Dynamic Array formula method. It can be found in Excel 2019 & 365.



                @ sign is almost identical to the older spreadsheet versions, except it uses @ to indicate where implicit intersection may be used, where older spreadsheet versions did this silently.



                Implicit intersection follows these rules:




                • If cell value is a single item, then return the item.


                • If values are in a range, then return the cell on the same row or column as the formula.


                • If it is an array, then pick the top-left value.



                Considering versions like 2013 & 2016, @ can be found with TABLE.



                enter image description here




                • Uses the Column header to carry values in the Row.

                • Consider the example below. If the formula begins with @, it doesn't return an error but removes the @sign as soon as it finishes with Enter, and gets the value 100.


                =@VLOOKUP(G112,A111:E111,2,FALSE)



                enter image description here



                N.B.



                With an older version of Excel, functions that return multi-cell ranges or an array will be prefixed with @.






                share|improve this answer















                @ sign is popularly knows as Implicit intersection operator to support Dynamic Array formula method. It can be found in Excel 2019 & 365.



                @ sign is almost identical to the older spreadsheet versions, except it uses @ to indicate where implicit intersection may be used, where older spreadsheet versions did this silently.



                Implicit intersection follows these rules:




                • If cell value is a single item, then return the item.


                • If values are in a range, then return the cell on the same row or column as the formula.


                • If it is an array, then pick the top-left value.



                Considering versions like 2013 & 2016, @ can be found with TABLE.



                enter image description here




                • Uses the Column header to carry values in the Row.

                • Consider the example below. If the formula begins with @, it doesn't return an error but removes the @sign as soon as it finishes with Enter, and gets the value 100.


                =@VLOOKUP(G112,A111:E111,2,FALSE)



                enter image description here



                N.B.



                With an older version of Excel, functions that return multi-cell ranges or an array will be prefixed with @.







                share|improve this answer














                share|improve this answer



                share|improve this answer








                edited yesterday









                fixer1234

                21.9k14 gold badges54 silver badges89 bronze badges




                21.9k14 gold badges54 silver badges89 bronze badges










                answered yesterday









                Rajesh SRajesh S

                5,5563 gold badges8 silver badges27 bronze badges




                5,5563 gold badges8 silver badges27 bronze badges


























                    1














                    '@' was the way you indicated the start of a formula in program Lotus. Then, Excel allowed for similar usage in addition to using "=", However,Excel automatically change '@' to '='.
                    For more details:
                    https://www.quora.com/What-does-the-symbol-do-in-Excel-It-keeps-showing-up-as-why-is-this-happening






                    share|improve this answer


























                    • This applies only to versions of Excel that don't have Dynamic Arrays. The new Dynamic Arrays have a different usage of the @ sign. See my answer for updates.

                      – teylyn
                      yesterday
















                    1














                    '@' was the way you indicated the start of a formula in program Lotus. Then, Excel allowed for similar usage in addition to using "=", However,Excel automatically change '@' to '='.
                    For more details:
                    https://www.quora.com/What-does-the-symbol-do-in-Excel-It-keeps-showing-up-as-why-is-this-happening






                    share|improve this answer


























                    • This applies only to versions of Excel that don't have Dynamic Arrays. The new Dynamic Arrays have a different usage of the @ sign. See my answer for updates.

                      – teylyn
                      yesterday














                    1












                    1








                    1







                    '@' was the way you indicated the start of a formula in program Lotus. Then, Excel allowed for similar usage in addition to using "=", However,Excel automatically change '@' to '='.
                    For more details:
                    https://www.quora.com/What-does-the-symbol-do-in-Excel-It-keeps-showing-up-as-why-is-this-happening






                    share|improve this answer













                    '@' was the way you indicated the start of a formula in program Lotus. Then, Excel allowed for similar usage in addition to using "=", However,Excel automatically change '@' to '='.
                    For more details:
                    https://www.quora.com/What-does-the-symbol-do-in-Excel-It-keeps-showing-up-as-why-is-this-happening







                    share|improve this answer












                    share|improve this answer



                    share|improve this answer










                    answered yesterday









                    AbdelAziz AbdelLatefAbdelAziz AbdelLatef

                    114 bronze badges




                    114 bronze badges
















                    • This applies only to versions of Excel that don't have Dynamic Arrays. The new Dynamic Arrays have a different usage of the @ sign. See my answer for updates.

                      – teylyn
                      yesterday



















                    • This applies only to versions of Excel that don't have Dynamic Arrays. The new Dynamic Arrays have a different usage of the @ sign. See my answer for updates.

                      – teylyn
                      yesterday

















                    This applies only to versions of Excel that don't have Dynamic Arrays. The new Dynamic Arrays have a different usage of the @ sign. See my answer for updates.

                    – teylyn
                    yesterday





                    This applies only to versions of Excel that don't have Dynamic Arrays. The new Dynamic Arrays have a different usage of the @ sign. See my answer for updates.

                    – teylyn
                    yesterday











                    0














                    I agree with AbdelAziz AbdelLatef.



                    I tested the "@" symbol in Excel, and I find Excel will immediately change to the equal sign. It seems that "@" is covered by "="



                    enter image description here



                    So this may not be a new feature of Excel. As far as I know, Recently the new functions are released by Excel is only available to Office Insiders at this time. You can review this in the link:
                    https://blog-insider.office.com/2019/06/13/dynamic-arrays-and-new-functions-in-excel/






                    share|improve this answer





















                    • 1





                      This is because you don't have an Excel version with Dynamic Arrays. I updated my answer with some more detail.

                      – teylyn
                      yesterday
















                    0














                    I agree with AbdelAziz AbdelLatef.



                    I tested the "@" symbol in Excel, and I find Excel will immediately change to the equal sign. It seems that "@" is covered by "="



                    enter image description here



                    So this may not be a new feature of Excel. As far as I know, Recently the new functions are released by Excel is only available to Office Insiders at this time. You can review this in the link:
                    https://blog-insider.office.com/2019/06/13/dynamic-arrays-and-new-functions-in-excel/






                    share|improve this answer





















                    • 1





                      This is because you don't have an Excel version with Dynamic Arrays. I updated my answer with some more detail.

                      – teylyn
                      yesterday














                    0












                    0








                    0







                    I agree with AbdelAziz AbdelLatef.



                    I tested the "@" symbol in Excel, and I find Excel will immediately change to the equal sign. It seems that "@" is covered by "="



                    enter image description here



                    So this may not be a new feature of Excel. As far as I know, Recently the new functions are released by Excel is only available to Office Insiders at this time. You can review this in the link:
                    https://blog-insider.office.com/2019/06/13/dynamic-arrays-and-new-functions-in-excel/






                    share|improve this answer













                    I agree with AbdelAziz AbdelLatef.



                    I tested the "@" symbol in Excel, and I find Excel will immediately change to the equal sign. It seems that "@" is covered by "="



                    enter image description here



                    So this may not be a new feature of Excel. As far as I know, Recently the new functions are released by Excel is only available to Office Insiders at this time. You can review this in the link:
                    https://blog-insider.office.com/2019/06/13/dynamic-arrays-and-new-functions-in-excel/







                    share|improve this answer












                    share|improve this answer



                    share|improve this answer










                    answered yesterday









                    Bella Bella

                    944 bronze badges




                    944 bronze badges











                    • 1





                      This is because you don't have an Excel version with Dynamic Arrays. I updated my answer with some more detail.

                      – teylyn
                      yesterday














                    • 1





                      This is because you don't have an Excel version with Dynamic Arrays. I updated my answer with some more detail.

                      – teylyn
                      yesterday








                    1




                    1





                    This is because you don't have an Excel version with Dynamic Arrays. I updated my answer with some more detail.

                    – teylyn
                    yesterday





                    This is because you don't have an Excel version with Dynamic Arrays. I updated my answer with some more detail.

                    – teylyn
                    yesterday


















                    draft saved

                    draft discarded




















































                    Thanks for contributing an answer to Super User!


                    • Please be sure to answer the question. Provide details and share your research!

                    But avoid



                    • Asking for help, clarification, or responding to other answers.

                    • Making statements based on opinion; back them up with references or personal experience.


                    To learn more, see our tips on writing great answers.




                    draft saved


                    draft discarded














                    StackExchange.ready(
                    function () {
                    StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1471013%2fin-the-beginning-of-a-formula%23new-answer', 'question_page');
                    }
                    );

                    Post as a guest















                    Required, but never shown





















































                    Required, but never shown














                    Required, but never shown












                    Required, but never shown







                    Required, but never shown

































                    Required, but never shown














                    Required, but never shown












                    Required, but never shown







                    Required, but never shown







                    Popular posts from this blog

                    Taj Mahal Inhaltsverzeichnis Aufbau | Geschichte | 350-Jahr-Feier | Heutige Bedeutung | Siehe auch |...

                    Baia Sprie Cuprins Etimologie | Istorie | Demografie | Politică și administrație | Arii naturale...

                    Nicolae Petrescu-Găină Cuprins Biografie | Opera | In memoriam | Varia | Controverse, incertitudini...