Juniper Systems Allegro DOS Manual User Manual
Page 145
Advertising
Windows CE Page 4-79
If you need to create a cell reference using row and column numbers
(column A has number 1) use function CellRef(col, row [, sheetIndex]).
Parameter sheetIndex is optional.
Example:
i = 1
while i < 100
Set(CellRef(1,i), i)
i = i+1
end
If Command
if condition then
commandsTrue
end
if condition then
commandsTrue
else
commandsFalse
end
Executes commandsTrue if a condition is True or commandsFalse if a
condition is False.
Examples:
if a1<>0 then Set(c1, b1/a1) end
if a1=0 then
Set(c1, "Sorry...")
else
Set(c1, b1/a1)
end
While Command
while condition
commands
end
Executes commands as long as a condition is True.
Example:
while a1>0
Set(CellRef(2, a1), a1*100)
Set(a1, a1-1)
end
Advertising