[macvoiceover] Re: Entering formulas in Numbers
- From: Ian Edwards <ianedwards42@xxxxxxxxx>
- To: macvoiceover@xxxxxxxxxxxxx
- Date: Tue, 26 Jun 2012 15:40:08 -0600
Thanks for your patience John. If I figure anything about this out I'll let the
list know as general information.
Cheers,
Ian
On 2012-06-26, at 3:34 PM, John Panarese wrote:
> This, I'm not sure of. Logically speaking, it shouldn't make a
> difference. I don't know why it would. However, I have not messed around
> with ranges like that.
>
>
> Take Care
>
> John D. Panarese
> Director
> Mac for the Blind
> Tel, (631) 724-4479
> Email, john@xxxxxxxxxxxxxxxxxx
> Website, http://www.macfortheblind.com
>
> APPLE CERTIFIED SUPPORT PROFESSIONAL FOR MAC OSX LION
>
> AUTHORIZED APPLE STORE BUSINESS AFFILIATE
>
> MAC and iOS VOICEOVER TRAINING AND SUPPORT
>
>
>
> On Jun 26, 2012, at 5:30 PM, Ian Edwards <ianedwards42@xxxxxxxxx> wrote:
>
>> You've got it just how I know it.
>>
>> I was trying to mimick what Voicover was saying with the whole imbeded thing.
>>
>> Here's what I've found playing around. It looks like I'm fine doing a sum
>> for a column, but it's not letting me use a range in a row. sosum(B7:B9)
>> worked, but sum(C7:I7) didn't. Is this normal that you can only use a column
>> to get a range sum? Maybe there's a different way of entering it when it's a
>> row?
>>
>> Ian
>>
>> On 2012-06-26, at 3:26 PM, John Panarese wrote:
>>
>>> I'm not sure what you mean. For example, if I want to add up all the
>>> items in a column, it would look like this, =sum(A2:A10) as the range.
>>> This should work. Unless I am misunderstanding what you are asking.
>>> Please let me know if I am not getting your question.
>>>
>>>
>>> Take Care
>>>
>>> John D. Panarese
>>> Director
>>> Mac for the Blind
>>> Tel, (631) 724-4479
>>> Email, john@xxxxxxxxxxxxxxxxxx
>>> Website, http://www.macfortheblind.com
>>>
>>> APPLE CERTIFIED SUPPORT PROFESSIONAL FOR MAC OSX LION
>>>
>>> AUTHORIZED APPLE STORE BUSINESS AFFILIATE
>>>
>>> MAC and iOS VOICEOVER TRAINING AND SUPPORT
>>>
>>>
>>>
>>> On Jun 26, 2012, at 5:18 PM, Ian Edwards <ianedwards42@xxxxxxxxx> wrote:
>>>
>>>> Thanks John. It's doing fine with formulas involving the plus sign, like
>>>> d7+e7 etc. It's a range I'm having truble with. When I go to the formula
>>>> edit box, I get imbeded cell fields, for example imbeded c7 plus imbeded
>>>> c8. When I try a formula with a range like sum, there is no punctuation or
>>>> symbol between the imbeded cell fields. So it doesn't say sum(imbeded
>>>> c7:imbeded i7), instead the cells are smushed together.
>>>>
>>>> Does that make sense to you, and if it does make sense, is this right? All
>>>> the guides I've read are about dragging and clicking and making sure the
>>>> colours match up, not typing in the raw formula. Any suggestions would be
>>>> helpful.
>>>>
>>>> Ian
>>>>
>>>> On 2012-06-26, at 2:39 PM, John Panarese wrote:
>>>>
>>>>> This looks fine. Instead of hitting enter, try navigating right to a
>>>>> confirm button. I use formulas in my spreadsheets and it's the same
>>>>> process as in Windows as far as I can recall.
>>>>>
>>>>>
>>>>> Take Care
>>>>>
>>>>> John D. Panarese
>>>>> Director
>>>>> Mac for the Blind
>>>>> Tel, (631) 724-4479
>>>>> Email, john@xxxxxxxxxxxxxxxxxx
>>>>> Website, http://www.macfortheblind.com
>>>>>
>>>>> APPLE CERTIFIED SUPPORT PROFESSIONAL FOR MAC OSX LION
>>>>>
>>>>> AUTHORIZED APPLE STORE BUSINESS AFFILIATE
>>>>>
>>>>> MAC and iOS VOICEOVER TRAINING AND SUPPORT
>>>>>
>>>>>
>>>>>
>>>>> On Jun 26, 2012, at 4:21 PM, Ian Edwards <ianedwards42@xxxxxxxxx> wrote:
>>>>>
>>>>>> Starting to play around with the Nurbers spreadsheet, and clearly I'm
>>>>>> getting somethign wrong.
>>>>>>
>>>>>> I hit the equals key, and it starts a formula. I then type in my
>>>>>> formula, say sum(c7:i7) and hit enter, but I get whacky values. It's
>>>>>> addings some things up, but not my whole range of cells.
>>>>>>
>>>>>> Ok, I'm taking my formula typing from my experience with Excel, is there
>>>>>> a different way of entering them in Numbers? I assumed there was a math
>>>>>> language standard.
>>>>>>
>>>>>> Thanks for help to anyone who has experience with the Numbers
>>>>>> spreadsheet.
>>>>>>
>>>>>> Ian
>>>>>>
>>>>>>>
>>>>>>> Click on the link below to go to our homepage.
>>>>>>> http://www.icanworkthisthing.com
>>>>>>>
>>>>>>> Manage your subscription by using the web interface on the link below.
>>>>>>> //www.freelists.org/list/macvoiceover
>>>>>>>
>>>>>>> Users can subscribe to this list by sending email to
>>>>>>> macvoiceover-request@xxxxxxxxxxxxx
>>>>>>> with 'subscribe' in the Subject field OR by logging into the Web
>>>>>>> interface at //www.freelists.org/list/macvoiceover
>>>>>>>
>>>>>
>>>>>>
>>>>>> Click on the link below to go to our homepage.
>>>>>> http://www.icanworkthisthing.com
>>>>>>
>>>>>> Manage your subscription by using the web interface on the link below.
>>>>>> //www.freelists.org/list/macvoiceover
>>>>>>
>>>>>> Users can subscribe to this list by sending email to
>>>>>> macvoiceover-request@xxxxxxxxxxxxx
>>>>>> with 'subscribe' in the Subject field OR by logging into the Web
>>>>>> interface at //www.freelists.org/list/macvoiceover
>>>>>>
>>>>
>>>>>
>>>>> Click on the link below to go to our homepage.
>>>>> http://www.icanworkthisthing.com
>>>>>
>>>>> Manage your subscription by using the web interface on the link below.
>>>>> //www.freelists.org/list/macvoiceover
>>>>>
>>>>> Users can subscribe to this list by sending email to
>>>>> macvoiceover-request@xxxxxxxxxxxxx
>>>>> with 'subscribe' in the Subject field OR by logging into the Web
>>>>> interface at //www.freelists.org/list/macvoiceover
>>>>>
>>>
>>>>
>>>> Click on the link below to go to our homepage.
>>>> http://www.icanworkthisthing.com
>>>>
>>>> Manage your subscription by using the web interface on the link below.
>>>> //www.freelists.org/list/macvoiceover
>>>>
>>>> Users can subscribe to this list by sending email to
>>>> macvoiceover-request@xxxxxxxxxxxxx
>>>> with 'subscribe' in the Subject field OR by logging into the Web
>>>> interface at //www.freelists.org/list/macvoiceover
>>>>
>>
>>>
>>> Click on the link below to go to our homepage.
>>> http://www.icanworkthisthing.com
>>>
>>> Manage your subscription by using the web interface on the link below.
>>> //www.freelists.org/list/macvoiceover
>>>
>>> Users can subscribe to this list by sending email to
>>> macvoiceover-request@xxxxxxxxxxxxx
>>> with 'subscribe' in the Subject field OR by logging into the Web
>>> interface at //www.freelists.org/list/macvoiceover
>>>
>
>>
>> Click on the link below to go to our homepage.
>> http://www.icanworkthisthing.com
>>
>> Manage your subscription by using the web interface on the link below.
>> //www.freelists.org/list/macvoiceover
>>
>> Users can subscribe to this list by sending email to
>> macvoiceover-request@xxxxxxxxxxxxx
>> with 'subscribe' in the Subject field OR by logging into the Web
>> interface at //www.freelists.org/list/macvoiceover
>>
>
> Click on the link below to go to our homepage.
> http://www.icanworkthisthing.com
>
> Manage your subscription by using the web interface on the link below.
> //www.freelists.org/list/macvoiceover
>
> Users can subscribe to this list by sending email to
> macvoiceover-request@xxxxxxxxxxxxx
> with 'subscribe' in the Subject field OR by logging into the Web
> interface at //www.freelists.org/list/macvoiceover
>
Other related posts:
