Juniper Systems Allegro DOS Manual User Manual

Page 145

Advertising
background image

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