Re: [AI] excel queries continued!
if you don't use f2 , and use numpad 0and 5 ,keeping numpad off , then it will read letter / digit by digit for one cell. will it do? gajendra vyas phone : 079-30127030 mobile : 9427065866 - Original Message - From: "Amar Jain" To: "accessindia" Sent: Thursday, February 05, 2015 1:44 PM Subject: Re: [AI] excel queries continued! Siddhi: no idea of how to read the value character by character, but this keystroke allows you to switch between formula and values. So once pressed, it will read as formula, and upon next press, it will read the value. But you may not be able to use the edit mode to check the value as per my understanding. Call up FS support directly no? -- Amar Jain. Website: www.amarjain.com Register at the dedicated AccessIndia list for discussing accessibility of mobile phones / Tabs on: http://mail.accessindia.org.in/mailman/listinfo/mobile.accessindia_accessindia.org.in Search for old postings at: http://www.mail-archive.com/accessindia@accessindia.org.in/ To unsubscribe send a message to accessindia-requ...@accessindia.org.in with the subject unsubscribe. To change your subscription to digest mode or make any other changes, please visit the list home page at http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in Disclaimer: 1. Contents of the mails, factual, or otherwise, reflect the thinking of the person sending the mail and AI in no way relates itself to its veracity; 2. AI cannot be held liable for any commission/omission based on the mails sent through this mailing list.. --- This email is free from viruses and malware because avast! Antivirus protection is active. http://www.avast.com Register at the dedicated AccessIndia list for discussing accessibility of mobile phones / Tabs on: http://mail.accessindia.org.in/mailman/listinfo/mobile.accessindia_accessindia.org.in Search for old postings at: http://www.mail-archive.com/accessindia@accessindia.org.in/ To unsubscribe send a message to accessindia-requ...@accessindia.org.in with the subject unsubscribe. To change your subscription to digest mode or make any other changes, please visit the list home page at http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in Disclaimer: 1. Contents of the mails, factual, or otherwise, reflect the thinking of the person sending the mail and AI in no way relates itself to its veracity; 2. AI cannot be held liable for any commission/omission based on the mails sent through this mailing list..
Re: [AI] excel queries continued!
Siddhi: no idea of how to read the value character by character, but this keystroke allows you to switch between formula and values. So once pressed, it will read as formula, and upon next press, it will read the value. But you may not be able to use the edit mode to check the value as per my understanding. Call up FS support directly no? -- Amar Jain. Website: www.amarjain.com Register at the dedicated AccessIndia list for discussing accessibility of mobile phones / Tabs on: http://mail.accessindia.org.in/mailman/listinfo/mobile.accessindia_accessindia.org.in Search for old postings at: http://www.mail-archive.com/accessindia@accessindia.org.in/ To unsubscribe send a message to accessindia-requ...@accessindia.org.in with the subject unsubscribe. To change your subscription to digest mode or make any other changes, please visit the list home page at http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in Disclaimer: 1. Contents of the mails, factual, or otherwise, reflect the thinking of the person sending the mail and AI in no way relates itself to its veracity; 2. AI cannot be held liable for any commission/omission based on the mails sent through this mailing list..
Re: [AI] excel queries continued!
Dear Siddhi, Only to add to the average formula, instead of using the formula =((A1+A2+A3)/3), you can use =AVERAGE (A1:A3). I don't know any other method to find the values other than what was mentioned in the list. -- Good friendship is like the relationship between eye & hand! If the hand is hurt, the eye will cry! & when the eye cries, the hand will wipe the tears!!! With best regards, Mahesh Narasimhan M: +91(0)9899353960 E: maheshde...@gmail.com On 2/4/15, Siddhi Desai wrote: > Thanks for the comment. > The problem is that that I have too many values in millions and > billionss located near each other with 100/100 matrix. So I was > wondering that is there any way we could read them character by > character within that cell only after entering the formula. as pasting > in other cell creats confusion. is there any laternative way? > > Amar, I tried what you said but it displays the formula. for example, > the in the cell a4, there is a formula of an average ((a1+a2+a3)/3) > and the answer is 6. when I use control `. it shows me the average > formula ((a1+a2+a3)/3) where earlier JAWS was announcing "6 has a > formula". > Am I doing correctly? or you were suggesting something else. > Thanking in advance > Sincerely > Siddhi > > > > Register at the dedicated AccessIndia list for discussing accessibility of > mobile phones / Tabs on: > http://mail.accessindia.org.in/mailman/listinfo/mobile.accessindia_accessindia.org.in > > > Search for old postings at: > http://www.mail-archive.com/accessindia@accessindia.org.in/ > > To unsubscribe send a message to > accessindia-requ...@accessindia.org.in > with the subject unsubscribe. > > To change your subscription to digest mode or make any other changes, please > visit the list home page at > http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in > > > Disclaimer: > 1. Contents of the mails, factual, or otherwise, reflect the thinking of the > person sending the mail and AI in no way relates itself to its veracity; > > 2. AI cannot be held liable for any commission/omission based on the mails > sent through this mailing list.. > Register at the dedicated AccessIndia list for discussing accessibility of mobile phones / Tabs on: http://mail.accessindia.org.in/mailman/listinfo/mobile.accessindia_accessindia.org.in Search for old postings at: http://www.mail-archive.com/accessindia@accessindia.org.in/ To unsubscribe send a message to accessindia-requ...@accessindia.org.in with the subject unsubscribe. To change your subscription to digest mode or make any other changes, please visit the list home page at http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in Disclaimer: 1. Contents of the mails, factual, or otherwise, reflect the thinking of the person sending the mail and AI in no way relates itself to its veracity; 2. AI cannot be held liable for any commission/omission based on the mails sent through this mailing list..
Re: [AI] excel queries continued!
Dear Siddhi,
As per my knowledge there is no alternative to read number character by
character. If you follow my suggestion then the cell will contain only
digits and not the formula. So you can read it by character by character.
In this case there is no need to paste it in another cell. You can get the
numbers in that particular cells only. If you don't mind do send the sample
dummy file and I will modify it for you to read numbers as per your
requirement.
Regards,
Mukesh Baviskar
Mobile: 9403161157
--
From: "Siddhi Desai"
Sent: Wednesday, February 04, 2015 11:25 PM
To: "AccessIndia: a list for discussing accessibility and issues
concerningthe disabled."
Subject: Re: [AI] excel queries continued!
Dear Mukesh Sir,
Thanks for the information.
My question was that if you have large number (in billions) and
formula in the same cell. is there anyway where you could read the
number charcter by charcter instead of pasting into other cell? as
when I press f2 JAWS reads to me the formula and not the number.
The average example was to confirm Amar's suggestion.
Thanks for the information though
Sincerely
Siddhi
On 2/4/15, Mukesh Baviskar wrote:
Hello Siddhi,
Take a try of macro.
code:
Sub AVG()
With Range("A4")
.FormulaR1C1 = "=AVERAGE((R[-3]C+R[-2]C+R[-1]C)/3)"
.Formula = .Value
End With
MsgBox "Done!"
End Sub
Save it in standard module using alt + f11, Insert-module-paste the code
and
run it.
Enable all macros. Save file as macro enable. Now you can read the digits
one by one using f2 edit command.
Hope this will solve your problem.
Regards,
Mukesh Baviskar
Mobile: 9403161157
--
From: "Siddhi Desai"
Sent: Wednesday, February 04, 2015 10:08 PM
To: "accessindia"
Subject: [AI] excel queries continued!
Thanks for the comment.
The problem is that that I have too many values in millions and
billionss located near each other with 100/100 matrix. So I was
wondering that is there any way we could read them character by
character within that cell only after entering the formula. as pasting
in other cell creats confusion. is there any laternative way?
Amar, I tried what you said but it displays the formula. for example,
the in the cell a4, there is a formula of an average ((a1+a2+a3)/3)
and the answer is 6. when I use control `. it shows me the average
formula ((a1+a2+a3)/3) where earlier JAWS was announcing "6 has a
formula".
Am I doing correctly? or you were suggesting something else.
Thanking in advance
Sincerely
Siddhi
Register at the dedicated AccessIndia list for discussing accessibility
of
mobile phones / Tabs on:
http://mail.accessindia.org.in/mailman/listinfo/mobile.accessindia_accessindia.org.in
Search for old postings at:
http://www.mail-archive.com/accessindia@accessindia.org.in/
To unsubscribe send a message to
accessindia-requ...@accessindia.org.in
with the subject unsubscribe.
To change your subscription to digest mode or make any other changes,
please visit the list home page at
http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in
Disclaimer:
1. Contents of the mails, factual, or otherwise, reflect the thinking of
the person sending the mail and AI in no way relates itself to its
veracity;
2. AI cannot be held liable for any commission/omission based on the
mails
sent through this mailing list..
Register at the dedicated AccessIndia list for discussing accessibility
of
mobile phones / Tabs on:
http://mail.accessindia.org.in/mailman/listinfo/mobile.accessindia_accessindia.org.in
Search for old postings at:
http://www.mail-archive.com/accessindia@accessindia.org.in/
To unsubscribe send a message to
accessindia-requ...@accessindia.org.in
with the subject unsubscribe.
To change your subscription to digest mode or make any other changes,
please
visit the list home page at
http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in
Disclaimer:
1. Contents of the mails, factual, or otherwise, reflect the thinking of
the
person sending the mail and AI in no way relates itself to its veracity;
2. AI cannot be held liable for any commission/omission based on the
mails
sent through this mailing list..
Register at the dedicated AccessIndia list for discussing accessibility of
mobile phones / Tabs on:
http://mail.accessindia.org.in/mailman/listinfo/mobile.accessindia_accessindia.org.in
Search for old postings at:
http://www.mail-archive.com/accessindia@accessindia.org.in/
To unsubscribe send a message to
accessindia-requ...@accessindia.org.in
with the subject unsubscribe.
To change your subscription to digest mode or make any other changes,
please visit the list home page at
http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in
Disclaimer:
1. Con
Re: [AI] excel queries continued!
Dear Mukesh Sir,
Thanks for the information.
My question was that if you have large number (in billions) and
formula in the same cell. is there anyway where you could read the
number charcter by charcter instead of pasting into other cell? as
when I press f2 JAWS reads to me the formula and not the number.
The average example was to confirm Amar's suggestion.
Thanks for the information though
Sincerely
Siddhi
On 2/4/15, Mukesh Baviskar wrote:
> Hello Siddhi,
> Take a try of macro.
>
> code:
>
> Sub AVG()
> With Range("A4")
> .FormulaR1C1 = "=AVERAGE((R[-3]C+R[-2]C+R[-1]C)/3)"
> .Formula = .Value
> End With
> MsgBox "Done!"
> End Sub
>
> Save it in standard module using alt + f11, Insert-module-paste the code and
>
> run it.
> Enable all macros. Save file as macro enable. Now you can read the digits
> one by one using f2 edit command.
>
> Hope this will solve your problem.
>
> Regards,
>
> Mukesh Baviskar
> Mobile: 9403161157
>
>
> ----------
> From: "Siddhi Desai"
> Sent: Wednesday, February 04, 2015 10:08 PM
> To: "accessindia"
> Subject: [AI] excel queries continued!
>
>> Thanks for the comment.
>> The problem is that that I have too many values in millions and
>> billionss located near each other with 100/100 matrix. So I was
>> wondering that is there any way we could read them character by
>> character within that cell only after entering the formula. as pasting
>> in other cell creats confusion. is there any laternative way?
>>
>> Amar, I tried what you said but it displays the formula. for example,
>> the in the cell a4, there is a formula of an average ((a1+a2+a3)/3)
>> and the answer is 6. when I use control `. it shows me the average
>> formula ((a1+a2+a3)/3) where earlier JAWS was announcing "6 has a
>> formula".
>> Am I doing correctly? or you were suggesting something else.
>> Thanking in advance
>> Sincerely
>> Siddhi
>>
>>
>>
>> Register at the dedicated AccessIndia list for discussing accessibility of
>>
>> mobile phones / Tabs on:
>> http://mail.accessindia.org.in/mailman/listinfo/mobile.accessindia_accessindia.org.in
>>
>>
>> Search for old postings at:
>> http://www.mail-archive.com/accessindia@accessindia.org.in/
>>
>> To unsubscribe send a message to
>> accessindia-requ...@accessindia.org.in
>> with the subject unsubscribe.
>>
>> To change your subscription to digest mode or make any other changes,
>> please visit the list home page at
>> http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in
>>
>>
>> Disclaimer:
>> 1. Contents of the mails, factual, or otherwise, reflect the thinking of
>> the person sending the mail and AI in no way relates itself to its
>> veracity;
>>
>> 2. AI cannot be held liable for any commission/omission based on the mails
>>
>> sent through this mailing list..
>
>
>
>
> Register at the dedicated AccessIndia list for discussing accessibility of
> mobile phones / Tabs on:
> http://mail.accessindia.org.in/mailman/listinfo/mobile.accessindia_accessindia.org.in
>
>
> Search for old postings at:
> http://www.mail-archive.com/accessindia@accessindia.org.in/
>
> To unsubscribe send a message to
> accessindia-requ...@accessindia.org.in
> with the subject unsubscribe.
>
> To change your subscription to digest mode or make any other changes, please
> visit the list home page at
> http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in
>
>
> Disclaimer:
> 1. Contents of the mails, factual, or otherwise, reflect the thinking of the
> person sending the mail and AI in no way relates itself to its veracity;
>
> 2. AI cannot be held liable for any commission/omission based on the mails
> sent through this mailing list..
>
Register at the dedicated AccessIndia list for discussing accessibility of
mobile phones / Tabs on:
http://mail.accessindia.org.in/mailman/listinfo/mobile.accessindia_accessindia.org.in
Search for old postings at:
http://www.mail-archive.com/accessindia@accessindia.org.in/
To unsubscribe send a message to
accessindia-requ...@accessindia.org.in
with the subject unsubscribe.
To change your subscription to digest mode or make any other changes, please
visit the list home page at
http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in
Disclaimer:
1. Contents of the mails, factual, or otherwise, reflect the thinking of the
person sending the mail and AI in no way relates itself to its veracity;
2. AI cannot be held liable for any commission/omission based on the mails sent
through this mailing list..
Re: [AI] excel queries continued!
Hello Siddhi,
Take a try of macro.
code:
Sub AVG()
With Range("A4")
.FormulaR1C1 = "=AVERAGE((R[-3]C+R[-2]C+R[-1]C)/3)"
.Formula = .Value
End With
MsgBox "Done!"
End Sub
Save it in standard module using alt + f11, Insert-module-paste the code and
run it.
Enable all macros. Save file as macro enable. Now you can read the digits
one by one using f2 edit command.
Hope this will solve your problem.
Regards,
Mukesh Baviskar
Mobile: 9403161157
--
From: "Siddhi Desai"
Sent: Wednesday, February 04, 2015 10:08 PM
To: "accessindia"
Subject: [AI] excel queries continued!
Thanks for the comment.
The problem is that that I have too many values in millions and
billionss located near each other with 100/100 matrix. So I was
wondering that is there any way we could read them character by
character within that cell only after entering the formula. as pasting
in other cell creats confusion. is there any laternative way?
Amar, I tried what you said but it displays the formula. for example,
the in the cell a4, there is a formula of an average ((a1+a2+a3)/3)
and the answer is 6. when I use control `. it shows me the average
formula ((a1+a2+a3)/3) where earlier JAWS was announcing "6 has a
formula".
Am I doing correctly? or you were suggesting something else.
Thanking in advance
Sincerely
Siddhi
Register at the dedicated AccessIndia list for discussing accessibility of
mobile phones / Tabs on:
http://mail.accessindia.org.in/mailman/listinfo/mobile.accessindia_accessindia.org.in
Search for old postings at:
http://www.mail-archive.com/accessindia@accessindia.org.in/
To unsubscribe send a message to
accessindia-requ...@accessindia.org.in
with the subject unsubscribe.
To change your subscription to digest mode or make any other changes,
please visit the list home page at
http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in
Disclaimer:
1. Contents of the mails, factual, or otherwise, reflect the thinking of
the person sending the mail and AI in no way relates itself to its
veracity;
2. AI cannot be held liable for any commission/omission based on the mails
sent through this mailing list..
Register at the dedicated AccessIndia list for discussing accessibility of
mobile phones / Tabs on:
http://mail.accessindia.org.in/mailman/listinfo/mobile.accessindia_accessindia.org.in
Search for old postings at:
http://www.mail-archive.com/accessindia@accessindia.org.in/
To unsubscribe send a message to
accessindia-requ...@accessindia.org.in
with the subject unsubscribe.
To change your subscription to digest mode or make any other changes, please
visit the list home page at
http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in
Disclaimer:
1. Contents of the mails, factual, or otherwise, reflect the thinking of the
person sending the mail and AI in no way relates itself to its veracity;
2. AI cannot be held liable for any commission/omission based on the mails sent
through this mailing list..
[AI] excel queries continued!
Thanks for the comment. The problem is that that I have too many values in millions and billionss located near each other with 100/100 matrix. So I was wondering that is there any way we could read them character by character within that cell only after entering the formula. as pasting in other cell creats confusion. is there any laternative way? Amar, I tried what you said but it displays the formula. for example, the in the cell a4, there is a formula of an average ((a1+a2+a3)/3) and the answer is 6. when I use control `. it shows me the average formula ((a1+a2+a3)/3) where earlier JAWS was announcing "6 has a formula". Am I doing correctly? or you were suggesting something else. Thanking in advance Sincerely Siddhi Register at the dedicated AccessIndia list for discussing accessibility of mobile phones / Tabs on: http://mail.accessindia.org.in/mailman/listinfo/mobile.accessindia_accessindia.org.in Search for old postings at: http://www.mail-archive.com/accessindia@accessindia.org.in/ To unsubscribe send a message to accessindia-requ...@accessindia.org.in with the subject unsubscribe. To change your subscription to digest mode or make any other changes, please visit the list home page at http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in Disclaimer: 1. Contents of the mails, factual, or otherwise, reflect the thinking of the person sending the mail and AI in no way relates itself to its veracity; 2. AI cannot be held liable for any commission/omission based on the mails sent through this mailing list..
Re: [AI] excel queries
Hi Sidhi, The another way to paste the value is by using the following method. Alt+E, S, V and hit enter key. -- Good friendship is like the relationship between eye & hand! If the hand is hurt, the eye will cry! & when the eye cries, the hand will wipe the tears!!! With best regards, Mahesh Narasimhan M: +91(0)9899353960 E: maheshde...@gmail.com On 2/2/15, Siddhi Desai wrote: > Dear All, > I think I have not explained very well. I will paste the text in my > book and may be it would be more clear. > text from the book > > We can also solve for the payment. Suppose we need $700 in five years > and believe that we can earn 16.9 percent per year on our investment. > We can find the amount we will need to invest each year to reach that > goal. If we put our cursor in an Excel cell, and type =PMT( we will > then see the formula that needs to be completed for Excel to solve for > the PMT. It will appear as: > PMT(rate, nper, pv, fv, type) > text in the book ends > When I hit = and start typing pmt, JAWS only announces payment and not > > PMT(rate, nper, pv, fv, type) > And if I try to understand through arrow keys it announces where I > want the result say, I am entering the formula in a1 and to type the > formula I hit "=" and type payment. Now, if I try to navigate through > arrows it would announce =b2, =c2 etc. > So I am not sure how to get access to > PMT(rate, nper, pv, fv, type) > > Sincerely > Siddhi > > On 2/2/15, Amiyo Biswas wrote: >> Hello, >> >> When we type something in an excel cell, we cannot use arrow keys. Then >> the >> >> cursor goes over to the next cell. If you are sure of the formula, simply >> go >> >> on entering it. Otherwise, use f2 key to switch over to the edit mode. In >> edit mode you can freely use arrow keys. F2 key also helps in reading or >> editing existing data. >> >> I am not sure if I understood your problem. Anyway, someone will come up >> with a better solution. >> >> With best regards, >> Amiyo Biswas >> Cell: +91-9433464329 >> >> >> - Original Message - >> From: "Siddhi Desai" >> To: "accessindia" >> Sent: Sunday, February 01, 2015 9:10 PM >> Subject: [AI] excel queries >> >> >>> Dear All, >>> 1. when you try to type in a particular formula say, payment or >>> average after hitting "equals" Jaws reads the average but I am not >>> sure how to enter the value in that formula? when we were entering >>> payment formula my friends could see the components of the formula >>> like rate, principle etc. How I get the Jaws read it? >>> 2. If I have the formula and the value in the cell. when I press f2 >>> Jaws reads out the formula to me. How can I read the content within >>> the cell? >>> 3. When I am entering the formula for the first time in the cell if I >>> try to use arrow keys instead of reading formula it read outs me >>> =j2,=j3. I think it announces where I want the result of formula to be >>> entered. How can I read the formula. >>> >>> The detail answers would be helpful! >>> Thanking in advance >>> Sincerely >>> Siddhi >>> >>> >>> >>> Register at the dedicated AccessIndia list for discussing accessibility >>> of >>> >>> mobile phones / Tabs on: >>> http://mail.accessindia.org.in/mailman/listinfo/mobile.accessindia_accessindia.org.in >>> >>> >>> Search for old postings at: >>> http://www.mail-archive.com/accessindia@accessindia.org.in/ >>> >>> To unsubscribe send a message to >>> accessindia-requ...@accessindia.org.in >>> with the subject unsubscribe. >>> >>> To change your subscription to digest mode or make any other changes, >>> please visit the list home page at >>> http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in >>> >>> >>> Disclaimer: >>> 1. Contents of the mails, factual, or otherwise, reflect the thinking of >>> the person sending the mail and AI in no way relates itself to its >>> veracity; >>> >>> 2. AI cannot be held liable for any commission/omission based on the >>> mails >>> >>> sent through this mailing list.. >> >> >> >> >> Register at the dedicated AccessIndia list for discussing accessibility >> of >> mobile phones / Tabs on: >> http://mail.accessindia.org.in/mailman/listinfo/mobile.accessindia_accessindia.org.in >> >> >
Re: [AI] excel queries
Rahul Bhaiya / Siddhi, For the problem no. 2, did you try switching between the formula and value in a cell by using Control `? Thanks -- Amar Jain. Website: www.amarjain.com Register at the dedicated AccessIndia list for discussing accessibility of mobile phones / Tabs on: http://mail.accessindia.org.in/mailman/listinfo/mobile.accessindia_accessindia.org.in Search for old postings at: http://www.mail-archive.com/accessindia@accessindia.org.in/ To unsubscribe send a message to accessindia-requ...@accessindia.org.in with the subject unsubscribe. To change your subscription to digest mode or make any other changes, please visit the list home page at http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in Disclaimer: 1. Contents of the mails, factual, or otherwise, reflect the thinking of the person sending the mail and AI in no way relates itself to its veracity; 2. AI cannot be held liable for any commission/omission based on the mails sent through this mailing list..
Re: [AI] excel queries
Hello Sidhy making an attempt to answer your questions. 1. When you try to type in a particular formula say, payment or Average after hitting "equals" Jaws reads the average but I am not Sure how to enter the value in that formula? When we were entering Payment formula my friends could see the components of the formula Like rate, principle etc. How I get the Jaws read it? A: use the insert function option as elaborated in my previous Email. 2. If I have the formula and the value in the cell. When I press f2 Jaws read out the formula to me. How can I read the content within? The cell? A: You may paste it as values in a different cell, to do this, navigate to a blank cell press application key, select paste special... and select values radio button and press enter. Now you will be able to read the value by pressing f2 key. 3. When I am entering the formula for the first time in the cell if I try to use arrow keys instead of reading formula it read outs me =j2,=j3. I think it announces where I want the result of formula to be Entered. How can I read the formula? a: when you are entering formula for the first time in a cell the arrow keys allows you to make the the values in other cells part of your formula. To read the formula with the help of arrow keys press enter and navigate outside the cell and once again press f2 to review the formula. HTH Best Rahul On 2/1/15, Siddhi Desai wrote: > Dear All, > 1. when you try to type in a particular formula say, payment or > average after hitting "equals" Jaws reads the average but I am not > sure how to enter the value in that formula? when we were entering > payment formula my friends could see the components of the formula > like rate, principle etc. How I get the Jaws read it? > 2. If I have the formula and the value in the cell. when I press f2 > Jaws reads out the formula to me. How can I read the content within > the cell? > 3. When I am entering the formula for the first time in the cell if I > try to use arrow keys instead of reading formula it read outs me > =j2,=j3. I think it announces where I want the result of formula to be > entered. How can I read the formula. > > The detail answers would be helpful! > Thanking in advance > Sincerely > Siddhi > > > > Register at the dedicated AccessIndia list for discussing accessibility of > mobile phones / Tabs on: > http://mail.accessindia.org.in/mailman/listinfo/mobile.accessindia_accessindia.org.in > > > Search for old postings at: > http://www.mail-archive.com/accessindia@accessindia.org.in/ > > To unsubscribe send a message to > accessindia-requ...@accessindia.org.in > with the subject unsubscribe. > > To change your subscription to digest mode or make any other changes, please > visit the list home page at > http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in > > > Disclaimer: > 1. Contents of the mails, factual, or otherwise, reflect the thinking of the > person sending the mail and AI in no way relates itself to its veracity; > > 2. AI cannot be held liable for any commission/omission based on the mails > sent through this mailing list.. > Register at the dedicated AccessIndia list for discussing accessibility of mobile phones / Tabs on: http://mail.accessindia.org.in/mailman/listinfo/mobile.accessindia_accessindia.org.in Search for old postings at: http://www.mail-archive.com/accessindia@accessindia.org.in/ To unsubscribe send a message to accessindia-requ...@accessindia.org.in with the subject unsubscribe. To change your subscription to digest mode or make any other changes, please visit the list home page at http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in Disclaimer: 1. Contents of the mails, factual, or otherwise, reflect the thinking of the person sending the mail and AI in no way relates itself to its veracity; 2. AI cannot be held liable for any commission/omission based on the mails sent through this mailing list..
Re: [AI] excel queries
Hello Sidhy TO read the function arguments that you are suppose to enter to get the final value, you may follow this alternative method. 1. Place your cursor on the desired cell when you wish to obtain the final result. 2. Press alt key to invoke the excel ribbon; navigate to the formula tab by pressing arrow keys. 3. Look for the "insert function under option "function library" and press enter. 4. Type the "PMT" in the edit field and pres enter on the search button, all matching values will be displayed. 5. Select the "PMT" function form the list and again press enter. 6. Now the form will be displayed with following fields, use tab key to navigate, for your ready reference I am also giving you the explanation of the function arguments that will be displayed in the form. Interest rate is the interest rate for the loan. number_payments is the number of payments for the loan. PV is the present value or principal of the loan. FV is optional. It is the future value or the loan amount outstanding after all payments have been made. If this parameter is omitted, the PMT function assumes a FV value of 0. Type is optional. It indicates when the payments are due. Type can be one of the following values: 0 Payments are due at the end of the period. (default) 1 Payments are due at the beginning of the period. Hope this helps. Best Rahul Gambhir On 2/1/15, Siddhi Desai wrote: > Dear All, > 1. when you try to type in a particular formula say, payment or > average after hitting "equals" Jaws reads the average but I am not > sure how to enter the value in that formula? when we were entering > payment formula my friends could see the components of the formula > like rate, principle etc. How I get the Jaws read it? > 2. If I have the formula and the value in the cell. when I press f2 > Jaws reads out the formula to me. How can I read the content within > the cell? > 3. When I am entering the formula for the first time in the cell if I > try to use arrow keys instead of reading formula it read outs me > =j2,=j3. I think it announces where I want the result of formula to be > entered. How can I read the formula. > > The detail answers would be helpful! > Thanking in advance > Sincerely > Siddhi > > > > Register at the dedicated AccessIndia list for discussing accessibility of > mobile phones / Tabs on: > http://mail.accessindia.org.in/mailman/listinfo/mobile.accessindia_accessindia.org.in > > > Search for old postings at: > http://www.mail-archive.com/accessindia@accessindia.org.in/ > > To unsubscribe send a message to > accessindia-requ...@accessindia.org.in > with the subject unsubscribe. > > To change your subscription to digest mode or make any other changes, please > visit the list home page at > http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in > > > Disclaimer: > 1. Contents of the mails, factual, or otherwise, reflect the thinking of the > person sending the mail and AI in no way relates itself to its veracity; > > 2. AI cannot be held liable for any commission/omission based on the mails > sent through this mailing list.. > Register at the dedicated AccessIndia list for discussing accessibility of mobile phones / Tabs on: http://mail.accessindia.org.in/mailman/listinfo/mobile.accessindia_accessindia.org.in Search for old postings at: http://www.mail-archive.com/accessindia@accessindia.org.in/ To unsubscribe send a message to accessindia-requ...@accessindia.org.in with the subject unsubscribe. To change your subscription to digest mode or make any other changes, please visit the list home page at http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in Disclaimer: 1. Contents of the mails, factual, or otherwise, reflect the thinking of the person sending the mail and AI in no way relates itself to its veracity; 2. AI cannot be held liable for any commission/omission based on the mails sent through this mailing list..
Re: [AI] excel queries
Dear All, I think I have not explained very well. I will paste the text in my book and may be it would be more clear. text from the book We can also solve for the payment. Suppose we need $700 in five years and believe that we can earn 16.9 percent per year on our investment. We can find the amount we will need to invest each year to reach that goal. If we put our cursor in an Excel cell, and type =PMT( we will then see the formula that needs to be completed for Excel to solve for the PMT. It will appear as: PMT(rate, nper, pv, fv, type) text in the book ends When I hit = and start typing pmt, JAWS only announces payment and not PMT(rate, nper, pv, fv, type) And if I try to understand through arrow keys it announces where I want the result say, I am entering the formula in a1 and to type the formula I hit "=" and type payment. Now, if I try to navigate through arrows it would announce =b2, =c2 etc. So I am not sure how to get access to PMT(rate, nper, pv, fv, type) Sincerely Siddhi On 2/2/15, Amiyo Biswas wrote: > Hello, > > When we type something in an excel cell, we cannot use arrow keys. Then the > > cursor goes over to the next cell. If you are sure of the formula, simply go > > on entering it. Otherwise, use f2 key to switch over to the edit mode. In > edit mode you can freely use arrow keys. F2 key also helps in reading or > editing existing data. > > I am not sure if I understood your problem. Anyway, someone will come up > with a better solution. > > With best regards, > Amiyo Biswas > Cell: +91-9433464329 > > > - Original Message - > From: "Siddhi Desai" > To: "accessindia" > Sent: Sunday, February 01, 2015 9:10 PM > Subject: [AI] excel queries > > >> Dear All, >> 1. when you try to type in a particular formula say, payment or >> average after hitting "equals" Jaws reads the average but I am not >> sure how to enter the value in that formula? when we were entering >> payment formula my friends could see the components of the formula >> like rate, principle etc. How I get the Jaws read it? >> 2. If I have the formula and the value in the cell. when I press f2 >> Jaws reads out the formula to me. How can I read the content within >> the cell? >> 3. When I am entering the formula for the first time in the cell if I >> try to use arrow keys instead of reading formula it read outs me >> =j2,=j3. I think it announces where I want the result of formula to be >> entered. How can I read the formula. >> >> The detail answers would be helpful! >> Thanking in advance >> Sincerely >> Siddhi >> >> >> >> Register at the dedicated AccessIndia list for discussing accessibility of >> >> mobile phones / Tabs on: >> http://mail.accessindia.org.in/mailman/listinfo/mobile.accessindia_accessindia.org.in >> >> >> Search for old postings at: >> http://www.mail-archive.com/accessindia@accessindia.org.in/ >> >> To unsubscribe send a message to >> accessindia-requ...@accessindia.org.in >> with the subject unsubscribe. >> >> To change your subscription to digest mode or make any other changes, >> please visit the list home page at >> http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in >> >> >> Disclaimer: >> 1. Contents of the mails, factual, or otherwise, reflect the thinking of >> the person sending the mail and AI in no way relates itself to its >> veracity; >> >> 2. AI cannot be held liable for any commission/omission based on the mails >> >> sent through this mailing list.. > > > > > Register at the dedicated AccessIndia list for discussing accessibility of > mobile phones / Tabs on: > http://mail.accessindia.org.in/mailman/listinfo/mobile.accessindia_accessindia.org.in > > > Search for old postings at: > http://www.mail-archive.com/accessindia@accessindia.org.in/ > > To unsubscribe send a message to > accessindia-requ...@accessindia.org.in > with the subject unsubscribe. > > To change your subscription to digest mode or make any other changes, please > visit the list home page at > http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in > > > Disclaimer: > 1. Contents of the mails, factual, or otherwise, reflect the thinking of the > person sending the mail and AI in no way relates itself to its veracity; > > 2. AI cannot be held liable for any commission/omission based on the mails > sent through this mailing list.. > Register at the dedicated AccessIndia list for discussing accessibility of mobile phones / Tabs on: http://mail.accessindia.org.in/mailman/listinfo/mobile.accessindia_ac
Re: [AI] excel queries
Hello, When we type something in an excel cell, we cannot use arrow keys. Then the cursor goes over to the next cell. If you are sure of the formula, simply go on entering it. Otherwise, use f2 key to switch over to the edit mode. In edit mode you can freely use arrow keys. F2 key also helps in reading or editing existing data. I am not sure if I understood your problem. Anyway, someone will come up with a better solution. With best regards, Amiyo Biswas Cell: +91-9433464329 - Original Message - From: "Siddhi Desai" To: "accessindia" Sent: Sunday, February 01, 2015 9:10 PM Subject: [AI] excel queries Dear All, 1. when you try to type in a particular formula say, payment or average after hitting "equals" Jaws reads the average but I am not sure how to enter the value in that formula? when we were entering payment formula my friends could see the components of the formula like rate, principle etc. How I get the Jaws read it? 2. If I have the formula and the value in the cell. when I press f2 Jaws reads out the formula to me. How can I read the content within the cell? 3. When I am entering the formula for the first time in the cell if I try to use arrow keys instead of reading formula it read outs me =j2,=j3. I think it announces where I want the result of formula to be entered. How can I read the formula. The detail answers would be helpful! Thanking in advance Sincerely Siddhi Register at the dedicated AccessIndia list for discussing accessibility of mobile phones / Tabs on: http://mail.accessindia.org.in/mailman/listinfo/mobile.accessindia_accessindia.org.in Search for old postings at: http://www.mail-archive.com/accessindia@accessindia.org.in/ To unsubscribe send a message to accessindia-requ...@accessindia.org.in with the subject unsubscribe. To change your subscription to digest mode or make any other changes, please visit the list home page at http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in Disclaimer: 1. Contents of the mails, factual, or otherwise, reflect the thinking of the person sending the mail and AI in no way relates itself to its veracity; 2. AI cannot be held liable for any commission/omission based on the mails sent through this mailing list.. Register at the dedicated AccessIndia list for discussing accessibility of mobile phones / Tabs on: http://mail.accessindia.org.in/mailman/listinfo/mobile.accessindia_accessindia.org.in Search for old postings at: http://www.mail-archive.com/accessindia@accessindia.org.in/ To unsubscribe send a message to accessindia-requ...@accessindia.org.in with the subject unsubscribe. To change your subscription to digest mode or make any other changes, please visit the list home page at http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in Disclaimer: 1. Contents of the mails, factual, or otherwise, reflect the thinking of the person sending the mail and AI in no way relates itself to its veracity; 2. AI cannot be held liable for any commission/omission based on the mails sent through this mailing list..
[AI] excel queries
Dear All, 1. when you try to type in a particular formula say, payment or average after hitting "equals" Jaws reads the average but I am not sure how to enter the value in that formula? when we were entering payment formula my friends could see the components of the formula like rate, principle etc. How I get the Jaws read it? 2. If I have the formula and the value in the cell. when I press f2 Jaws reads out the formula to me. How can I read the content within the cell? 3. When I am entering the formula for the first time in the cell if I try to use arrow keys instead of reading formula it read outs me =j2,=j3. I think it announces where I want the result of formula to be entered. How can I read the formula. The detail answers would be helpful! Thanking in advance Sincerely Siddhi Register at the dedicated AccessIndia list for discussing accessibility of mobile phones / Tabs on: http://mail.accessindia.org.in/mailman/listinfo/mobile.accessindia_accessindia.org.in Search for old postings at: http://www.mail-archive.com/accessindia@accessindia.org.in/ To unsubscribe send a message to accessindia-requ...@accessindia.org.in with the subject unsubscribe. To change your subscription to digest mode or make any other changes, please visit the list home page at http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in Disclaimer: 1. Contents of the mails, factual, or otherwise, reflect the thinking of the person sending the mail and AI in no way relates itself to its veracity; 2. AI cannot be held liable for any commission/omission based on the mails sent through this mailing list..
