If that's the case, how do I add a formula to a cell but keep the cell label?
For the second part, what I want is for each row of column 14 to be automatically filled in using the values of three other columns in that row. Specifying, say, g2+h2 will not work for l3, I'd need g3+h3. There has to be a way to generalize this for a whole column... On Oct 8, 2013, at 11:47 AM, Tim Kilburn <[email protected]> wrote: > Hi, > > When focus is on a specific cell and you are entering data into that cell, > you are actually entering the data into the Formula field. This is normal > Spreadsheet behaviour. The entry field is actually separate from the cell > itself. This is how you can know both the result of a given formula and the > formula itself for each cell. > > I'm not sure what you're asking for the second question. Are you trying to > put all three entries from columns 7, 8 and 10 into 14? Are you wanting some > function to be performed? Sorry, I'm not getting it. > > Later... > > Tim Kilburn > Fort McMurray, AB Canada > > On 2013-10-08, at 9:28 AM, Alex Hall <[email protected]> wrote: > >> Hi again, and sorry for all the questions about Numbers. I'm trying to add a >> formula to a column, a simple subtraction of three other columns. When I hit >> equals, I can type my formula, but then the title I gave the column is gone >> (I pressed equals on the header cell of the column). If I stop interacting a >> few times I can find a formula area; how is this different from what happens >> when I press equals? Which should I use? On a side note, what's the syntax >> for using only columns? That is, any entry in column 14 should be >> auto-filled by the entries in columns 7, 8, and 10 for every row, so >> absolute cell coordinates won't work. >> >> >> Have a great day, >> Alex (msg sent from Mac Mini) >> [email protected] >> >> >> >> -- >> You received this message because you are subscribed to the Google Groups >> "MacVisionaries" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to [email protected]. >> To post to this group, send email to [email protected]. >> Visit this group at http://groups.google.com/group/macvisionaries. >> For more options, visit https://groups.google.com/groups/opt_out. > > > -- > You received this message because you are subscribed to the Google Groups > "MacVisionaries" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To post to this group, send email to [email protected]. > Visit this group at http://groups.google.com/group/macvisionaries. > For more options, visit https://groups.google.com/groups/opt_out. Have a great day, Alex (msg sent from Mac Mini) [email protected] -- You received this message because you are subscribed to the Google Groups "MacVisionaries" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/macvisionaries. For more options, visit https://groups.google.com/groups/opt_out.
