Hi there
Let me see if I can clear up some things. First, the top row is the role that
voiceOver uses to announce your labels. I got told by somebody that the column
on the left column A, is what voiceOver uses to say the columns. So, you would
not have your formula in the same cell that you have your label.
So now let's do an example, and see if this helps. What if you put Monday
Tuesday Wednesday Thursday and Friday across the rows so you could have your
mileage amounts for these days. You would then go inffthe Inspector and make
the days into Text. You go below each day and put in some numbers. Just so you
know you've got everything right, put in some easy numbers !start with; then
you can take them out later.
Now you can draw a line or put in equal signs like I mentioned earlier so that
you have a separator between the numbers you put in andthe formula. Using our
example, go below Monday and get into the Insert menu and go down to Function.
Choose Sum and press enter. You should find the total forthe numbers you just
put in for Monday. Use -mand c !copy your formula. Get on top of Tuesday
!pressing the right arrow. Press the shift key and select the next four
columns. Now press -mand v !paste your formula in. You have now copied Monday's
formula inffthe other days.
Now let's add in a number into your row because you forgot some. Go one cell
above the line that you draw so you are on top of a number you put in earlier.
If you want a row below that number, press option down arrow. If you want it
the other way, press option up arrow. VoiceOver will tell you that you have
a.ed a row. Go back to Monday and put in some numbers. If you have done things
right, your formula will reflect the numbers you a.ed.
The reason I tell you !get on top the numbers you put in before adding your
rows is so that your new rows don't become text which will prevent them from
being a.ed inffyr formula.
I don't do the automatic fill-ins that you are talking about, but I will tell
you that Numbers will accept Excel formulas. Therefore, if you know how !write
such formulas in Excel, it should work in Numbers as well. Numbers formulas, if
you type them in by hand, are started in the same way they are in ,excel 0us+ !
equals key 6/>t ! =mula4 ,if y ne$ me to1 ,i c ask my husb& h{ 6d ? 9,excel 2c
he us$ 6t1* ,excel = ,brookhav5 ,college4 ,!n y cd try 8 idea4
,i alm c rememb} h{ 2c ,i did "s?+ = employ;t taxes 6calculate social tax
automatic,y4 ,x "w$1 too1 b ,ih 6ask my resid5t exp}t h{ 6set x up4 ,he j us$
,excel =mulas 6d x4
,reg>ds1
,gigi
Sent from my iPhone
> On Oct 8, 2013, at 6:30 PM, Alex Hall <[email protected]> wrote:
>
> 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.
--
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.
