HELPTEXT 18.HLP
FILE INFORMATION
FILENAME(S): HELPTEXT 18.HLP
FILE TYPE(S): SEQ
FILE SIZE: 1.5K
FIRST SEEN: 2025-11-30 19:47:13
APPEARS ON: 3 disk(s)
FILE HASH
adaab13e7a7eb40760f9ded36f806072c94827a108de0263057c63b5ca7d9e85
FOUND ON DISKS (3 DISKS)
| DISK TITLE | FILENAME | FILE TYPE | COLLECTION | TRACK | SECTOR | ACTIONS |
|---|---|---|---|---|---|---|
| BFS 102986 11S1 | HELPTEXT 18.HLP | SEQ | Curtcool, Frank | 9 | 18 | DOWNLOAD FILE |
| BUSINESS FORM | HELPTEXT 18.HLP | SEQ | DuncanTwain | 9 | 18 | DOWNLOAD FILE |
| BUSINESS FORM | HELPTEXT 18.HLP | SEQ | hedning, Martin L0fgren | 9 | 18 | DOWNLOAD FILE |
FILE CONTENT & ANALYSIS
00000000: 3F 66 6F 72 6D 75 6C 61 73 FF 61 20 66 4F 52 4D |?formulas.a fORM| 00000010: 55 4C 41 20 49 53 20 41 20 4D 41 54 48 45 4D 41 |ULA IS A MATHEMA| 00000020: 54 49 43 41 4C FF 45 58 50 52 45 53 53 49 4F 4E |TICAL.EXPRESSION| 00000030: 20 55 53 45 44 20 54 4F 20 4F 50 45 52 41 54 45 | USED TO OPERATE| 00000040: 20 4F 4E 20 4E 55 4D 42 45 52 53 FF 4F 52 20 44 | ON NUMBERS.OR D| 00000050: 41 54 45 53 2E FF FF 66 6F 72 6D 75 6C 61 20 20 |ATES...formula | 00000060: 20 20 20 5B 4C 41 42 45 4C 5D 3D 4D 41 54 48 20 | [LABEL]=MATH | 00000070: 45 58 50 52 45 53 53 49 4F 4E 2C 20 FF 20 20 20 |EXPRESSION, . | 00000080: 20 20 20 20 20 20 20 20 20 20 20 5B 4E 55 4D 45 | [NUME| 00000090: 52 49 43 20 4F 52 20 44 41 54 45 20 46 4F 52 4D |RIC OR DATE FORM| 000000A0: 41 54 5D 20 FF FF 74 48 45 20 46 4F 4C 4C 4F 57 |AT] ..tHE FOLLOW| 000000B0: 49 4E 47 20 46 55 4E 43 54 49 4F 4E 53 20 41 52 |ING FUNCTIONS AR| 000000C0: 45 20 49 4E 43 4C 55 44 45 44 FF 41 53 20 55 53 |E INCLUDED.AS US| 000000D0: 45 52 20 4F 50 54 49 4F 4E 53 20 49 4E 20 46 4F |ER OPTIONS IN FO| 000000E0: 52 4D 55 4C 41 20 45 4E 54 52 59 FF FF 6E 6F 74 |RMULA ENTRY..not| 000000F0: 65 31 3A 20 27 65 78 70 27 20 57 49 4C 4C 20 42 |e1: 'exp' WILL B| 00000100: 45 20 55 53 45 44 20 54 4F 20 53 49 47 4E 49 46 |E USED TO SIGNIF| 00000110: 59 20 41 FF 4D 41 54 48 4D 41 54 49 43 41 4C 20 |Y A.MATHMATICAL | 00000120: 45 58 50 52 45 53 53 49 4F 4E 2C 20 46 4F 52 4D |EXPRESSION, FORM| 00000130: 55 4C 41 20 4F 52 FF 41 4D 4F 55 4E 54 2E FF 6E |ULA OR.AMOUNT..n| 00000140: 6F 74 65 32 3A 20 27 6C 6F 63 31 27 20 41 4E 44 |ote2: 'loc1' AND| 00000150: 20 27 6C 6F 63 32 27 20 57 49 4C 4C 20 42 45 20 | 'loc2' WILL BE | 00000160: 55 53 45 44 20 FF 48 45 52 45 20 54 4F 20 53 49 |USED .HERE TO SI| 00000170: 47 4E 49 46 59 20 41 20 43 4F 4F 52 44 49 4E 41 |GNIFY A COORDINA| 00000180: 54 45 20 52 41 4E 47 45 FF 53 55 43 48 20 41 53 |TE RANGE.SUCH AS| 00000190: 20 72 31 20 54 4F 20 72 35 30 2E FF 5B 2B 5D 20 | r1 TO r50..[+] | 000001A0: 20 20 20 20 20 20 20 20 20 20 20 20 61 44 44 49 | aDDI| 000001B0: 54 49 4F 4E FF FF 5B 2D 5D 20 20 20 20 20 20 20 |TION..[-] | 000001C0: 20 20 20 20 20 20 73 55 42 54 52 41 43 54 49 4F | sUBTRACTIO| 000001D0: 4E FF FF 5B 2A 5D 20 20 20 20 20 20 20 20 20 20 |N..[*] | 000001E0: 20 20 20 6D 55 4C 54 49 50 4C 49 43 41 54 49 4F | mULTIPLICATIO| 000001F0: 4E FF FF 5B 2F 5D 20 20 20 20 20 20 20 20 20 20 |N..[/] | 00000200: 20 20 20 64 49 56 49 53 49 4F 4E FF FF 5B 5E 5D | dIVISION..[^]| 00000210: 20 20 20 20 20 20 20 20 20 20 20 20 20 72 41 49 | rAI| 00000220: 53 45 20 54 4F 20 41 20 50 4F 57 45 52 FF FF 69 |SE TO A POWER..i| 00000230: 6E 74 28 65 78 70 29 20 20 20 20 20 20 20 20 72 |nt(exp) r| 00000240: 45 54 55 52 4E 53 20 54 48 45 20 49 4E 54 45 47 |ETURNS THE INTEG| 00000250: 45 52 FF 20 20 20 20 20 20 20 20 20 20 20 20 20 |ER. | 00000260: 20 20 20 56 41 4C 55 45 20 4F 46 20 54 48 45 FF | VALUE OF THE.| 00000270: 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 | | 00000280: 45 58 50 52 45 53 53 49 4F 4E FF FF FF FF 61 62 |EXPRESSION....ab| 00000290: 73 28 65 78 70 29 20 20 20 20 20 20 20 20 72 45 |s(exp) rE| 000002A0: 54 55 52 4E 53 20 54 48 45 20 41 42 53 4F 4C 55 |TURNS THE ABSOLU| 000002B0: 54 45 FF 20 20 20 20 20 20 20 20 20 20 20 20 20 |TE. | 000002C0: 20 20 20 56 41 4C 55 45 20 4F 46 20 54 48 45 FF | VALUE OF THE.| 000002D0: 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 | | 000002E0: 45 58 50 52 45 53 53 49 4F 4E FF FF 73 67 6E 28 |EXPRESSION..sgn(| 000002F0: 65 78 70 29 20 20 20 20 20 20 20 20 72 45 54 55 |exp) rETU| 00000300: 52 4E 53 20 54 48 45 20 56 41 4C 55 45 20 31 FF |RNS THE VALUE 1.| 00000310: 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 | | 00000320: 49 46 20 45 58 50 20 49 53 20 50 4F 53 49 54 49 |IF EXP IS POSITI| 00000330: 56 45 2C 20 30 FF 20 20 20 20 20 20 20 20 20 20 |VE, 0. | 00000340: 20 20 20 20 20 20 49 46 20 45 58 50 20 49 53 20 | IF EXP IS | 00000350: 5A 45 52 4F 2C 20 41 4E 44 20 2D 31 FF 20 20 20 |ZERO, AND -1. | 00000360: 20 20 20 20 20 20 20 20 20 20 20 20 20 49 46 20 | IF | 00000370: 45 58 50 20 49 53 20 4E 45 47 41 54 49 56 45 2E |EXP IS NEGATIVE.| 00000380: FF FF 70 63 74 28 65 78 70 29 20 20 20 20 20 20 |..pct(exp) | 00000390: 20 20 72 45 54 55 52 4E 53 20 54 48 45 20 50 45 | rETURNS THE PE| 000003A0: 52 43 45 4E 54 FF 20 20 20 20 20 20 20 20 20 20 |RCENT. | 000003B0: 20 20 20 20 20 20 56 41 4C 55 45 20 4F 46 20 54 | VALUE OF T| 000003C0: 48 45 FF 20 20 20 20 20 20 20 20 20 20 20 20 20 |HE. | 000003D0: 20 20 20 45 58 50 52 45 53 53 49 4F 4E FF FF 73 | EXPRESSION..s| 000003E0: 75 6D 28 6C 6F 63 31 3A 6C 6F 63 32 29 20 20 61 |um(loc1:loc2) a| 000003F0: 44 44 53 20 54 48 45 20 56 41 4C 55 45 53 20 49 |DDS THE VALUES I| 00000400: 4E FF 20 20 20 20 20 20 20 20 20 20 20 20 20 20 |N. | 00000410: 20 20 4C 4F 43 41 54 49 4F 4E 53 20 31 20 54 48 | LOCATIONS 1 TH| 00000420: 52 4F 55 47 48 20 32 FF FF 61 76 67 28 6C 6F 63 |ROUGH 2..avg(loc| 00000430: 31 3A 6C 6F 63 32 29 20 20 72 45 54 55 52 4E 53 |1:loc2) rETURNS| 00000440: 20 54 48 45 20 41 56 45 52 41 47 45 20 4F 46 FF | THE AVERAGE OF.| 00000450: 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 | | 00000460: 4C 4F 43 41 54 49 4F 4E 53 20 31 20 54 48 52 4F |LOCATIONS 1 THRO| 00000470: 55 47 48 20 32 FF FF 6D 69 6E 28 6C 6F 63 31 3A |UGH 2..min(loc1:| 00000480: 6C 6F 63 32 29 20 20 63 4F 4D 50 41 52 45 53 20 |loc2) cOMPARES | 00000490: 4C 4F 43 41 54 49 4F 4E 53 20 31 FF 20 20 20 20 |LOCATIONS 1. | 000004A0: 20 20 20 20 20 20 20 20 20 20 20 20 54 48 52 4F | THRO| 000004B0: 55 47 48 20 32 20 41 4E 44 20 52 45 54 55 52 4E |UGH 2 AND RETURN| 000004C0: 53 20 FF 20 20 20 20 20 20 20 20 20 20 20 20 20 |S . | 000004D0: 20 20 20 54 48 45 20 4D 49 4E 49 4D 55 4D 20 56 | THE MINIMUM V| 000004E0: 41 4C 55 45 2E FF FF 6D 61 78 28 6C 6F 63 31 3A |ALUE...max(loc1:| 000004F0: 6C 6F 63 32 29 20 20 63 4F 4D 50 41 52 45 53 20 |loc2) cOMPARES | 00000500: 4C 4F 43 41 54 49 4F 4E 53 20 31 FF 20 20 20 20 |LOCATIONS 1. | 00000510: 20 20 20 20 20 20 20 20 20 20 20 20 54 48 52 4F | THRO| 00000520: 55 47 48 20 32 20 41 4E 44 20 52 45 54 55 52 4E |UGH 2 AND RETURN| 00000530: 53 FF 20 20 20 20 20 20 20 20 20 20 20 20 20 20 |S. | 00000540: 20 20 54 48 45 20 4D 41 58 49 4D 55 4D 20 56 41 | THE MAXIMUM VA| 00000550: 4C 55 45 2E FF FF 63 6E 74 28 6C 6F 63 31 3B 6C |LUE...cnt(loc1;l| 00000560: 6F 63 32 29 20 20 74 48 45 20 52 45 53 55 4C 54 |oc2) tHE RESULT| 00000570: 20 49 53 20 54 48 45 FF 20 20 20 20 20 20 20 20 | IS THE. | 00000580: 20 20 20 20 20 20 20 20 4E 55 4D 42 45 52 20 4F | NUMBER O| 00000590: 46 20 45 4E 54 52 49 45 53 20 49 4E FF 20 20 20 |F ENTRIES IN. | 000005A0: 20 20 20 20 20 20 20 20 20 20 20 20 20 54 48 45 | THE| 000005B0: 20 43 4F 4F 52 44 49 4E 41 54 45 20 52 41 4E 47 | COORDINATE RANG| 000005C0: 45 FF 20 20 20 20 20 20 20 20 20 20 20 20 20 20 |E. | 000005D0: 20 20 4F 46 20 4C 4F 43 41 54 49 4F 4E 53 20 31 | OF LOCATIONS 1| 000005E0: 20 41 4E 44 20 32 FF | AND 2. |
?FORMULAS.A FORMULA IS A MATHEMATICAL.EX
PRESSION USED TO OPERATE ON NUMBERS.OR D
ATES...FORMULA [LABEL]=MATH EXPRESSI
ON, . [NUMERIC OR DATE FORM
AT] ..THE FOLLOWING FUNCTIONS ARE INCLUD
ED.AS USER OPTIONS IN FORMULA ENTRY..NOT
E1: 'EXP' WILL BE USED TO SIGNIFY A.MATH
MATICAL EXPRESSION, FORMULA OR.AMOUNT..N
OTE2: 'LOC1' AND 'LOC2' WILL BE USED .HE
RE TO SIGNIFY A COORDINATE RANGE.SUCH AS
R1 TO R50..[+] ADDITION..[-
] SUBTRACTION..[*]
MULTIPLICATION..[/] DIVIS
ION..[^] RAISE TO A POWER..I
NT(EXP) RETURNS THE INTEGER.
VALUE OF THE.
EXPRESSION....ABS(EXP) RETURNS TH
E ABSOLUTE. VALUE OF THE.
EXPRESSION..SGN(EXP)
RETURNS THE VALUE 1.
IF EXP IS POSITIVE, 0. IF
EXP IS ZERO, AND -1. IF
EXP IS NEGATIVE...PCT(EXP) RETURN
S THE PERCENT. VALUE OF T
HE. EXPRESSION..SUM(LOC1:
LOC2) ADDS THE VALUES IN.
LOCATIONS 1 THROUGH 2..AVG(LOC1:LOC2)
RETURNS THE AVERAGE OF.
LOCATIONS 1 THROUGH 2..MIN(LOC1:LOC2) C
OMPARES LOCATIONS 1. THRO
UGH 2 AND RETURNS . THE M
INIMUM VALUE...MAX(LOC1:LOC2) COMPARES
LOCATIONS 1. THROUGH 2 AN
D RETURNS. THE MAXIMUM VA
LUE...CNT(LOC1;LOC2) THE RESULT IS THE.
NUMBER OF ENTRIES IN.
THE COORDINATE RANGE.
OF LOCATIONS 1 AND 2.
> CLICK IMAGE PREVIEW FOR FULL MODAL