formulas in Excel
Excel needs to know that you are entering a formula instead of data. So for example if you type into a cell "2+3" you might just be talking about 2+3=17, not wanting Excel to calculate it. To tell Excel you are entering a formula, you first press the = (equals) sign. JAWS will say "type in a formula and press enter".toggle quoted messageShow quoted text
Formula coordinates can be entered in at least two ways.
1. Enter numbers, =2+3 and press enter. JAWS will read the sum, 5.
2. Use cell attributes for your data. =a1+a2 enter. If a1 is 4 and a2 is 6, JAWS will read the sum, 10.
The beauty of Excel is that when the number in a1 changes, the sum in the formula cell changes to reflect that. So if your formula is in a3, and instead of 4 in a1 you have 17, the number in a3 will change from 10 to 23 without your doing anything to it.
If you put numbers into a cell instead of cell coordinates, of course, you have to change the number.
Excel is a sheet of rows and columns. The rows are designated by numbers and the columns by letters. So the third column in the second row would be c2. Columns always come before rows, just as 'c' comes before 'r'.
At 09:12 AM 9/24/2015, you wrote:
I've been following this thread, and I'd also would like to understand formulas, especially if there's a method to building your own.I think this kind of information is invaluable, especially myself.