{S:X;X;0;0;Namesá\ùá▐artá1{ITR-X}by Gerald L Fitton}
{S:X;X;0;1;Keywords:{ITT-X}VAT Names Fitton}
{S:X;X;0;2;Why Use Names{ITR-X}{ITR-X}Names are faster than using ranges and use up less memory, so it\æs a good idea to use named area in your spreadsheets rather than a range, especially if a function containing a range is replicated over a large area of your spreadsheet.á}
{S:X;X;0;3;Problems with Undefined Names{ITR-X}{ITR-X}Sometimes difficulties arise because Resultz can use names to refer to values, to slots or to ranges. Load the file [StartEnd] and you will see that the value typed in slot a1 is start-end. The error message Name not defined appears in the status line. Resultz has assumed that start and end are names and the hyphen, \Ö, between them means subtract end from start. You will also notice that although you might have typed Start with a capital S, but, when you click on the green tick (or tap <Return>) the S appears as a lower case s. Names are not case sensitive so that Start and start are the same name.}
{S:X;X;0;4;To overcome these problems you may need to change the Effectá\ùáNumberá\ùánewáobject setting to text or to enter the text in a different way. For example you can enter Start to End or Start_End.}
{S:X;X;0;5;Defining a Name{ITR-X}{ITR-X}Using the file [StartEnd] place the pointer over the italic f (just to the right of the Charts button and to the left of the cross and tick boxes). This italic f is called the formula button. Click the select (left) mouse button and you will find a menu containing Namesá.á.á. appears. Select Names and click on New in the Names window. Define Start (or start) as 12 by typing Start into the dialogue box called Name and 12 into the dialogue box called Value. Repeat the process to define End as 9. When you have defined the two names, the error message in [StartEnd] disappears and the value 3 appears in its place.}
{S:X;X;0;6;Using Names{ITR-X}{ITR-X}Load the file [VAT01]. Position the pointer in slot b7. Click select and change the value to 20 (in the formula line). Do not type the % sign. Click select on the green tick and the new value of VAT will be entered into the sheet. You will not be surprised to see the values of the VAT column, c, change and the changes ripple through column d and row 17. However, if you position the pointer in slot c12 and click select you will find, not b12*b6/100 as you might suppose, but b12*VAT/100 as the formula. The Name VAT has been defined as the value of slot b7.}
{S:X;X;0;7;A \Ébug\æ?{ITR-X}{ITR-X}I think I have discovered a \Ébug\æ. Load [VAT02] and change the 1 in b4 to 3. The value in b6 will change but the effect will not ripple through column c. If you study the names I have used you will see that it should. With 3 in b4 select slot c11, click in the formula line and on the green tick. The formula for c11 is recalculated\ÿbut it should have recalculated before!}
{S:X;X;0;8;I think it\æs a \Ébug\æ. If so, then be careful until it\æs fixed.}
{S:X;X;0;9;Summary{ITR-X}{ITR-X}Names can refer to values, slot references, ranges and arrays. Although I have not included an example in this directory, names can refer to text strings as well as numbers.}
