@If(Test,Result1,Result0)

@Choose(Number,ListSeparatedByCommas)

@Cellpointer(attribute); @Cell(attribute,cell); @Cellindex(block,col#,row#)

Attributes include: address (twodaddress,threedaddress,fulladdress); row; col; sheet; contents; format; type; prefix; width; notebookpath; etc.

@Is (blank, block, err, number, string, etc.)

@Type(Value/Cell)

@Property("Object.Property") Objects include: Active_Block, Active_Page, Active_Notebook, Application

@Command("CommandEquivalent") Objects of the commands include: Page, Notebook, Application

@@(SingleCellText) contents of the cell; @@(BlockOfReferences) array of contents of cells referred to; @@(BlockText) coordinates as text - wrapped in @@ to use

@Address(Row#, Col#,|RefType|,|Format|,|Page|) Reftype (1-8) is the sort of absolute addressing ($); Format is absolute or relative.

@Offset(StartCellBlock,Rowt#,Col#,|RowsHigh,ColumnsWide|)

@Blockname(Block); @Blocknames(Block) creates array

@Concatenate

@Clean, @Trim

@Char

@Repeat(Text,#Repetitions)

@Left, @Right, @Mid(Text,StartOffset,Number)

@Field(Text,Number,Delimiter)

@Substitute(Text,PartToReplace,ReplacementText)

@Replace(Text,StartOffset,Number,NewText)

@Setstring(Text,Length,Alignment)

@Upper, @Lower, @Proper

@Length

@Find(Subtext,Text,0)

@Sumif(Block,Criterion,DataColumn)

@Largest(Block,Rank#), @Smallest(Block,Rank#)

@Rank(Number,ArrayOfNumbers,Ascending?)

@Round(Number,Magnitude); @Trunc(Number,Magnitude)

@Mod(x,y)

@Today, @Now

@Date, @Year, @Month, @Day

@Dateinfo(Date#,Info#)

@Weekday (1-7=Sun-Sat; options), @Wkday (1-7=Sat-Fri)

@DateDif(StartDate,EndDate,Option)

@Time, @Hour, @Minute, @Second

@String(Number,Decimal)

@Fixed(Number,Decimal,NoCommas)

@Dollar(Number,Decimal)

@Dollartext(Number,FormatOption)

@Fraction(x,y)

@Char(Number), @Code(character)

@Value, @Datevalue, @Timevalue

@Cols, @Rows, @Sheets

@Column, @Row

@Indextoletter, @Lettertoindex

@Count, @Countblank

@Countif

@Lastcellvalue(block,|Type|)

@Lookup(valueinfirstarray,firstarray,secondarray)

@Vlookup(indexvalue,block,col#,|Exact?|)

@Hlookup(indexvalue,block,row#,0)

@Vhlookup(Valueinindexcol,Valueinindexrow,Block)

@Index(Block,Col#,Row#)

@Xindex(Block,Colhead,Rowhead)

@Match(Iitemtomatch,Array,|Exact?|)

@Maxlookup, @Minloookup

{Cell}{Branch Cell} {Quit} {Return}

{For CounterCell,Start#,Stop#,Step#,MacroCell}

{OnError}

{WindowsOff}

{Calc} {Recalc} {RecalcCol}

{Notebook.Recalc_Settings "Automatic;Natural;1;Yes;No"}

{PlayPerfectScript}

{Exec CommandLine,WindowMode}

{U}{D}{L}{R}{Home}{End}{PgDn}{PgUp}

{SelectBlock CellorBlock|,ActiveCell|}

{EditGoto CellorBlock|,ExtendCurrentSelection|}

{Navigate.SelectTable}

{Beep Pitch#}

{Message MsgBlock,ScreenX,ScreenY,|Expiration|}

{Alert Title,Message,ChoiceCell|,ButtonType,Icon,DefaultButton|} Choices: OK/1, Cancel/2, Abort/3, Retry/4, Ignore/5, Yes/6, No/7.
Buttons are 0(OK), 1(OK/Cancel), 2(Abort/Retry/Ignore), 3(Yes/No/Cancel),4(Yes/No),5(Retry/Cancel).
Icons are: 0(x), 1(?), 2(!), 3(I).
Default: 0(1st),1(2d).

{Get KeystrokeCell}

{GetNumber Prompt,NumberCell}

{GetLabel Prompt,TextCell}

{Menubranch MenuBlock}

{Vline}{HLine}

{FileSaveAs FileName,,,FileFormat}

{Open TextFileName,RorWorA}

{Close}

{WriteLn Text1|,Text2,Text3,...|}

{Write Text1|,Text2,Text3,...|}

{ReadLn Cell}

{FileSize Cell}

{GetPos Cell}

{GetDirectoryContents Cell,FileName}

{GetProperty TargetCell,Property}

{GetObjectProperty TargetCell,Object.Property}

{SetProperty Property,Option}

{SetObjectProperty Object.Property,Option}

SetObjectProperty
PasteSpecial
Paste
BlockCopy
BlockValues
Put
PutBlock2
PutCell2
Let
Remote source?	Y	Y	Y	Y	Y	Y	N	N	Y
Remote target?	Y	N	Y	Y	Y	Y	N	N	Y
Block as source?	N	N	N	N	Y	Y	Y	Y	N
Block as target?	N	N	Y	N	Y	Y	Y	Y	N
Reformat target?	N	N	N	N	Y	Opt	Y	Opt	Opt
Convert formulas?	Y*	Opt	Opt	Y*	Y	N	N	Opt	Y
Blanks as zero?	Y	Y	Y	Y	N	N	N	N	N
Add ' prefix?	Y	N	N	Y	N	N	N	N	N
{Let TargetCell,Data|:string|}

{PutCell Data|,DateOption|}

{PutCell2 Data}

{PutBlock Data|,TargetBlock||,DateOption|}

{PutBlock2 Data|,TargetBlock|}

{Put Block,Col#,Row#,Data}

{BlockValues SourceBlock,TargetCell}

{BlockCopy SourceBlock,TargetCell|,ModelCopy?,Options|} Options (1/0): Formulas?,Values?,Properties?,Objects?,Row/Col_Sizes?

{EditCopy} and {EditPaste}

{PasteSpecial Options} Options: "Label cells", "Number cells", "Formula cells", "Formula Values", "Properties", "Transpose"

{Contents TargetCell,SourceCell,|Width|,|NumericFormat#|}

{Blank}, {EditClear}, {ClearFormats}

Application (qp; "QuattroPro"; Default!)

vData=qp.GetCellValue("A:A1")

vBlock=qp.Eval("@COUNT(A:A1..A1000)")

qp.ExecMacro(;"C:B1")

qp.ExecMacro("C:\Spreadsheets\MyData.qpw";"C:B1")