the formula editor gets a little tricky at times. For the most part, you can edit the formula like you would text in a textedit doc. put the cursor to the left of a term like the b9, press shift right arrow to select and then delete it. then type in the new term, like b10 or whatever. You can also select, delete and change functions out of the formula too in the same way. But, it takes some trial and error to know how to edit the formula without messing it all up. You can read the entire formula token by token by using VO Shift and the arrow keys, the same as you would read a text doc character by character. You have to mess around with it a bit to get the hang of it. if at any time you feel like you really screwed things up, just stop interacting with the formula and press cancel, or just hit escape. Good luck with it. BTW: you should probably read through the help documentation for formulas in the numbers help system. You should know about things like address referencing for relative and absolute references. Absolute references use a dollar sign before the letter or number of a cell reference to make that row or column, or both, an absolute instead of relative address. > On Mar 13, 2015, at 6:37 PM, Jürgen Fleger <[email protected]> wrote: > > Hi Phil, > > thanks, you made my day. :-) It worked perfectly well. > You might be able to teach me something else: When I use the formular editor > to take its suggestions for ranges, strange things apeared. I used the arrow > keys to walk through it. It read content of cells but also numbers like 2:2, > 3:3, 4:4 and so forth. I didn’t get what it meant. Could you help me to > understand? > And: I defined the range b7 to b9 to be in the formular. What if I want to > add later cell b10 as well? Do I have to change the complete formular or is > there a way to define a range in a formular more openly? > > Thanks and > all the best > Jürgen > > > >> Am 13.03.2015 um 23:02 schrieb Phil Halton <[email protected]>: >> >> try =sum(Table A::b7:b9)*0.4 >> put this formula in the table B cell. Make sure you get the table name >> exact. the formula editor will suggest the table name after you type a few >> letters and you can just hit enter when it gets the right table name, then >> just continue typing your formula. >> The problem you are having is with the set of parenthesis that begins after >> the table name. that’s a syntax error because you were typing it in the >> middle of a data identifier. The sum function parenthesis are all you need >> here. >> >>> On Mar 13, 2015, at 4:58 PM, Jürgen Fleger <[email protected]> wrote: >>> >>> Hi, >>> >>> here's something I come not along. Would be great if someone could help me >>> understand: >>> >>> I have a sheet with two tables. Table A and Table B. I want to sum three >>> cells from table a and multiply it with 0.4. I want the result to apear in >>> Table b in a specific cell. So I tried several writings for the formular >>> but nothing worked. Here's something I beleive I came close: >>> =SUM(Table A::(B7:B9))×0.4 >>> >>> Unfortunately it didn't work. Do you have an idea what could be more >>> successful? >>> >>> Thanks and >>> all the best >>> Jürgen >>> >>> -- >>> 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/d/optout. >> >> -- >> 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/d/optout. > > -- > 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/d/optout.
-- 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/d/optout.
