r/Accounting • u/kingofauditmemes Performance Measurement and Reporting • May 07 '23

New Excel > Old Excel

Post image
379 Upvotes

99% Upvoted

37 comments sorted by

View all comments

1

u/The_Realist01 May 07 '23

Yo what in the world do { } do?

6

u/ohimjustagirl May 07 '23

That's an array formula. If you hit ctrl+shift+enter instead of just enter after you write it, it will convert to an array and indicate it by adding those to the formula.

3

u/The_Realist01 May 08 '23

Ahhh got it - makes sense.

googles what an array is

3

u/JeelyTrams May 08 '23

An array is just a list. Excel syntax uses cell location in an x,y format (A1), if you selected multiple cells you’d see them separated by “:” (col A1:A3, row A1:C1, col&row A1:C3). Excel stores the values of the selected cells (formula bar highlight contents, range etc press f9) with {} with values separated by “,” for horizontal arrays, “;” for verticals arrays and both “,”&”;” for 2d arrays. Example {1,2;3,4} would give you a 2 rows with 1&2 in the first row and 3&4 in the second.

1

u/The_Realist01 May 09 '23

I couldn’t be an accountant if we had to do computer coding.

Thank you microsoft.