[macvoiceover] Re: Entering formulas in Numbers

  • From: John Panarese <jpanarese@xxxxxxxxx>
  • To: macvoiceover@xxxxxxxxxxxxx
  • Date: Tue, 26 Jun 2012 17:43:07 -0400

    Please do.  I use Numbers, so it will be useful and helpful to me.


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:40 PM, Ian Edwards <ianedwards42@xxxxxxxxx> wrote:

> 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
>> 

>
> 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: