having issues with a array formula.

Question

WHen i type my formula It needs to have {} around it i believe this is an array formula. I'm using =Table(,G101) and no matter what i do CMD+shft+enter it text wraps to another line and wont add the {} in front and back of the code

please help.

thanks

riny_van_eekelen · Answer

cbishop395&nbsp;Not sure what you have in mind with&nbsp;=Table(,G101). The comma seems out of place and not sure what =Table(G101) should achieve either.&nbsp;Anyway, if you&nbsp;intend to enter an array formula you should use Ctrl-Shift-Enter. Not Cmd-Shift-Enter. Are you on a Mac by any chance?&nbsp;Please share a file (Onedrive or similar) or at least some screenshots that demonstrate your intentions.

detlef_lewin · Answer

cbishop395&nbsp;Could it be What-if-analysis with datatable?https://support.microsoft.com/en-us/office/calculate-multiple-results-by-using-a-data-table-in-excel-for-mac-f295baa8-afd7-40e1-9c68-f4f5373a2614&nbsp;

Forum Discussion

having issues with a array formula.

Resources