[ms-xlsx]: Excel (. xlsx) Extensions to the Office Open xml spreadsheetml file Format Intellectual Property Rights Notice for Open Specifications Documentation

455normdist-params = "(" argument "," argument "," argument "," argument ")" 40

456norm-dist-params = "(" argument "," argument "," argument "," argument ")" 40

457norminv-params = "(" argument "," argument "," argument ")" 40

458norm-inv-params = "(" argument "," argument "," argument ")" 40

459norm-s-dist-params = "(" argument "," argument ")" 40

460normsdist-params = "(" argument-expression ")" 40

461normsinv-params = "(" argument-expression ")" 40

462norm-s-inv-params = "(" argument-expression ")" 40

463not-params = "(" argument-expression ")" 40

464now-params = emptyparams 40

465n-params = "(" argument-expression ")" 40

466nper-params = "(" argument "," argument "," argument ["," argument ["," argument]] ")" 41

467npv-params = "(" argument "," argument *253("," argument) ")" 41

468numberstring-params = "(" argument "," argument ")" 41

469numbervalue-params = "(" (argument-expression / (argument "," argument ["," argument])) ")" 41

470oct2bin-params = "(" (argument-expression / (argument "," argument)) ")" 41

471oct2dec-params = "(" argument-expression ")" 41

472oct2hex-params = "(" (argument-expression / (argument "," argument)) ")" 41

473oddfprice-params = "(" argument "," argument "," argument "," argument "," argument "," argument "," argument "," argument ["," argument] ")" 41

474oddfyield-params = "(" argument "," argument "," argument "," argument "," argument "," argument "," argument "," argument ["," argument] ")" 41

475oddlprice-params = "(" argument "," argument "," argument "," argument "," argument "," argument "," argument ["," argument] ")" 41

476oddlyield-params = "(" argument "," argument "," argument "," argument "," argument "," argument "," argument ["," argument] ")" 41

477odd-params = "(" argument-expression ")" 41

478offset-params = "(" ref-argument-expression "," argument "," argument ["," argument ["," argument]] ")" 41

479or-params = "(" (argument-expression / (argument 1*254("," argument))) ")" 41

480pduration-params = "(" argument "," argument "," argument ")" 41

481pearson-params = "(" argument "," argument ")" 41

482percentile-exc-params = "(" argument "," argument ")" 41

483percentile-inc-params = "(" argument "," argument ")" 41

484percentile-params = "(" argument "," argument ")" 41

485percentrank-exc-params = "(" argument "," argument ["," argument] ")" 41

486percentrank-inc-params = "(" argument "," argument ["," argument] ")" 41

487percentrank-params = "(" argument "," argument ["," argument] ")" 41

488permutationa-params = "(" argument "," argument ")" 41

489permut-params = "(" argument "," argument ")" 41

490phi-params = "(" argument-expression ")" 41

491phonetic-params = "(" ref-argument-expression ")" 41

492pi-params = emptyparams 42

493pmt-params = "(" argument "," argument "," argument ["," argument ["," argument]] ")" 42

494poisson-dist-params = "(" argument "," argument "," argument ")" 42

495poisson-params = "(" argument "," argument "," argument ")" 42

496power-params = "(" argument "," argument ")" 42

497ppmt-params = "(" argument "," argument "," argument "," argument ["," argument ["," argument]] ")" 42

498pricedisc-params = "(" argument "," argument "," argument "," argument ["," argument] ")" 42

499pricemat-params = "(" argument "," argument "," argument "," argument "," argument ["," argument] ")" 42

500price-params = "(" argument "," argument "," argument "," argument "," argument "," argument ["," argument] ")" 42

501prob-params = "(" argument "," argument "," argument ["," argument] ")" 42

502product-params = "(" (argument-expression / (argument 1*254("," argument))) ")" 42

503proper-params = "(" argument-expression ")" 42

504pv-params = "(" argument "," argument "," argument ["," argument ["," argument]] ")" 42

505quartile-exc-params = "(" argument "," argument ")" 42

506quartile-inc-params = "(" argument "," argument ")" 42

507quartile-params = "(" argument "," argument ")" 42

508querystring-params = "(" argument "," argument *126( "," argument "," argument) ")" 42

509quotient-params = "(" argument "," argument ")" 42

510radians-params = "(" argument-expression ")" 42

511randbetween-params = "(" argument "," argument ")" 42

512rand-params = emptyparams 42

513rank-avg-params = "(" argument "," ref-argument-expression ["," argument] ")" 42

514rank-eq-params = "(" argument "," ref-argument-expression ["," argument] ")" 42

515rank-params = "(" argument "," ref-argument-expression ["," argument] ")" 42

516rate-params = "(" argument "," argument "," argument ["," argument ["," argument ["," argument]]] ")" 42

517received-params = "(" argument "," argument "," argument "," argument ["," argument] ")" 42

518replaceb-params = "(" argument "," argument "," argument "," argument ")" 43

519replace-params = "(" argument "," argument "," argument "," argument ")" 43

520rept-params = "(" argument "," argument ")" 43

521rightb-params = "(" (argument-expression / (argument "," argument)) ")" 43

522right-params = "(" (argument-expression / (argument "," argument)) ")" 43

523roman-params = "(" (argument-expression / (argument "," argument)) ")" 43

524roundbahtdown-params = "(" argument-expression ")" 43

525roundbahtup-params = "(" argument-expression ")" 43

526rounddown-params = "(" argument "," argument ")" 43

527round-params = "(" argument "," argument ")" 43

528roundup-params = "(" argument "," argument ")" 43

529row-params = "(" [ref-argument-expression ] ")" 43

530rows-params = "(" argument-expression ")" 43

531rri-params = "(" argument "," argument "," argument ")" 43

532rsq-params = "(" argument "," argument ")" 43

533rtd-params = "(" argument "," argument "," argument *252("," argument) ")" 43

534searchb-params = "(" argument "," argument ["," argument] ")" 43

535search-params = "(" argument "," argument ["," argument] ")" 43

536sech-params = "(" argument-expression ")" 43

537second-params = "(" argument-expression ")" 43

538sec-params = "(" argument-expression ")" 43

539series-params = "(" argument "," argument "," argument "," argument ["," argument] ")" 43

540seriessum-params = "(" argument "," argument "," argument "," argument ")" 43

541sheet-params = "(" argument ")" 43

542sheets-params = "(" argument ")" 43

543sign-params = "(" argument-expression ")" 43

544sinh-params = "(" argument-expression ")" 43

545sin-params = "(" argument-expression ")" 43

546skew-params = "(" (argument-expression / (argument 1*254("," argument))) ")" 44

547skew-p-params = "(" (argument-expression / (argument 1*253("," argument))) ")" 44

548sln-params = "(" argument "," argument "," argument ")" 44

549slope-params = "(" argument "," argument ")" 44

550small-params = "(" argument "," argument ")" 44

551sqrt-params = "(" argument-expression ")" 44

552sqrtpi-params = "(" argument-expression ")" 44

553standardize-params = "(" argument "," argument "," argument ")" 44

554stdeva-params = "(" (argument-expression / (argument 1*254("," argument))) ")" 44

555stdevpa-params = "(" (argument-expression / (argument 1*254("," argument))) ")" 44

556stdev-params = "(" (argument-expression / (argument 1*254("," argument))) ")" 44

557stdev-p-params = "(" (argument-expression / (argument 1*253("," argument))) ")" 44

558stdevp-params = "(" (argument-expression / (argument 1*254("," argument))) ")" 44

559stdev-s-params = "(" (argument-expression / (argument 1*253("," argument))) ")" 44

560steyx-params = "(" argument "," argument ")" 44

561substitute-params = "(" argument "," argument "," argument ["," argument] ")" 44

562subtotal-params = "(" argument "," ref-argument-expression *253("," ref-argument-expression ) ")" 44

563sumif-params = "(" ref-argument-expression "," argument ["," ref-argument-expression ] ")" 44

564sumifs-params = "(" ref-argument-expression "," ref-argument-expression "," argument *126("," ref-argument-expression "," argument) ")" 44

565sum-params = "(" (argument-expression / (argument 1*254("," argument))) ")" 44

566sumproduct-params = "(" (argument-expression / (argument 1*254("," argument))) ")" 44

567sumsq-params = "(" (argument-expression / (argument 1*254("," argument))) ")" 44

568sumx2my2-params = "(" argument "," argument ")" 44

569sumx2py2-params = "(" argument "," argument ")" 44

570sumxmy2-params = "(" argument "," argument ")" 44

571switch-params = "(" argument "," argument "," argument 1*251("," argument) ")" 44

572syd-params = "(" argument "," argument "," argument "," argument ")" 44

573tanh-params = "(" argument-expression ")" 45

574tan-params = "(" argument-expression ")" 45

575tbilleq-params = "(" argument "," argument "," argument ")" 45

576tbillprice-params = "(" argument "," argument "," argument ")" 45

577tbillyield-params = "(" argument "," argument "," argument ")" 45

578t-dist-2t-params = "(" argument "," argument ")" 45

579tdist-params = "(" argument "," argument "," argument ")" 45

580t-dist-params = "(" argument "," argument "," argument ")" 45

581t-dist-rt-params = "(" argument "," argument ")" 45

582text-params = "(" argument "," argument ")" 45

583textjoin-params = "(" argument "," argument "," argument *251("," argument) ")" 45

584thaidayofweek-params = "(" argument-expression ")" 45

585thaidigit-params = "(" argument-expression ")" 45

586thaimonthofyear-params = "(" argument-expression ")" 45

587thainumsound-params = "(" argument-expression ")" 45

588thainumstring-params = "(" argument-expression ")" 45

589thaistringlength-params = "(" argument-expression ")" 45

590thaiyear-params = "(" argument-expression ")" 45

591time-params = "(" argument "," argument "," argument ")" 45

592timevalue-params = "(" argument-expression ")" 45

593t-inv-2t-params = "(" argument "," argument ")" 45

594tinv-params = "(" argument "," argument ")" 45

595t-inv-params = "(" argument "," argument ")" 45

596today-params = emptyparams 45

597t-params = "(" argument-expression ")" 45

598transpose-params = "(" argument-expression ")" 45

599trend-params = "(" (argument-expression / (argument "," argument ["," argument ["," argument]])) ")" 45

600trimmean-params = "(" argument "," argument ")" 45

601trim-params = "(" argument-expression ")" 46

602true-params = emptyparams 46

603trunc-params = "(" (argument-expression / (argument "," argument)) ")" 46

604ttest-params = "(" argument "," argument "," argument "," argument ")" 46

605t-test-params = "(" argument "," argument "," argument "," argument ")" 46

606type-params = "(" argument-expression ")" 46

607unichar-params = "(" argument-expression ")" 46

608unicode-params = "(" argument-expression ")" 46

609upper-params = "(" argument-expression ")" 46

610usdollar-params = "(" (argument-expression / (argument "," argument)) ")" 46

611value-params = "(" argument-expression ")" 46

612vara-params = "(" (argument-expression / (argument 1*254("," argument))) ")" 46

613varpa-params = "(" (argument-expression / (argument 1*254("," argument))) ")" 46

614var-params = "(" (argument-expression / (argument 1*254("," argument))) ")" 46

615var-p-params = "(" (argument-expression / (argument 1*253("," argument))) ")" 46

616varp-params = "(" (argument-expression / (argument 1*254("," argument))) ")" 46

617var-s-params = "(" (argument-expression / (argument 1*253("," argument))) ")" 46

618vdb-params = "(" argument "," argument "," argument "," argument "," argument ["," argument ["," argument]] ")" 46

619vlookup-params = "(" argument "," argument "," argument ["," argument] ")" 46

620webservice-params = "(" (argument-expression / (argument "," argument)) ")" 46

621weekday-params = "(" (argument-expression / (argument "," argument)) ")" 46

622weeknum-params = "(" (argument-expression / (argument "," argument)) ")" 46

623weibull-dist-params = "(" argument "," argument "," argument "," argument ")" 46

624weibull-params = "(" argument "," argument "," argument "," argument ")" 46

625workday-intl-params = "(" argument "," argument ["," argument ["," argument]] ")" 46

626workday-params = "(" argument "," argument ["," argument] ")" 46

627xirr-params = "(" argument "," argument ["," argument] ")" 46

628xnpv-params = "(" argument "," argument "," argument ")" 46

629xor-params = "(" (argument-expression / (argument 1*253("," argument))) ")" 47

630yearfrac-params = "(" argument "," argument ["," argument] ")" 47

631year-params = "(" argument-expression ")" 47

632yielddisc-params = "(" argument "," argument "," argument "," argument ["," argument] ")" 47

633yieldmat-params = "(" argument "," argument "," argument "," argument "," argument ["," argument] ")" 47

634yield-params = "(" argument "," argument "," argument "," argument "," argument "," argument ["," argument] ")" 47

635ztest-params = "(" argument "," argument ["," argument] ")" 47

636z-test-params = "(" argument "," argument ["," argument] ")" 47

638ref-macro-function-call = "ABSREF" absref-params / "ACTIVE.CELL" active-cell-params / "CALL" call-params / "CALLER" caller-params / "EVALUATE" evaluate-params / "GET.DOCUMENT" get-document-params / "INPUT" input-params / "LAST.ERROR" last-error-params / "SCENARIO.GET" scenario-get-params / "SELECTION" selection-params / "TEXTREF" textref-params / "VIEW.GET" view-get-params 47

639macro-function-call = ref-macro-function-call / "ADD.BAR" add-bar-params / "ADD.COMMAND" add-command-params / "ADD.MENU" add-menu-params / "ADD.TOOLBAR" add-toolbar-params / "APP.TITLE" app-title-params / "ARGUMENT" argument-params / "BREAK" break-params / "CANCEL.KEY" cancel-key-params / "CHECK.COMMAND" check-command-params / "CREATE.OBJECT" create-object-params / "CUSTOM.REPEAT" custom-repeat-params / "CUSTOM.UNDO" custom-undo-params / "DELETE.BAR" delete-bar-params / "DELETE.COMMAND" delete-command-params / "DELETE.MENU" delete-menu-params / "DELETE.TOOLBAR" delete-toolbar-params / "DEREF" deref-params / "DIALOG.BOX" dialog-box-params / "DIRECTORY" directory-params / "DOCUMENTS" documents-params / "ECHO" echo-params / "ELSE" else-params / "ELSE.IF" else-if-params / "ENABLE.COMMAND" enable-command-params / "ENABLE.TOOL" enable-tool-params / "END.IF" end-if-params / "ERROR" error-params / "EXEC" exec-params / "EXECUTE" execute-params / "FCLOSE" fclose-params / "FILES" files-params / "FOPEN" fopen-params / "FOR" for-params / "FOR.CELL" for-cell-params / "FORMULA.CONVERT" formula-convert-params / "FPOS" fpos-params / "FREAD" fread-params / "FREADLN" freadln-params / "FSIZE" fsize-params / "FWRITE" fwrite-params / "FWRITELN" fwriteln-params / "GET.BAR" get-bar-params / "GET.CELL" get-cell-params / "GET.CHART.ITEM" get-chart-item-params / "GET.DEF" get-def-params / "GET.FORMULA" get-formula-params / "GET.LINK.INFO" get-link-info-params / "GET.MOVIE" get-movie-params / "GET.NAME" get-name-params / "GET.NOTE" get-note-params / "GET.OBJECT" get-object-params / "GET.TOOL" get-tool-params / "GET.TOOLBAR" get-toolbar-params / "GET.WINDOW" get-window-params / "GET.WORKBOOK" get-workbook-params / "GET.WORKSPACE" get-workspace-params / "GOTO" goto-params / "GROUP" group-params / "HALT" halt-params / "HELP" help-params / "INITIATE" initiate-params / "LINKS" links-params / "MOVIE.COMMAND" movie-command-params / "NAMES" names-params / "NEXT" next-params / "NOTE" note-params / "OPEN.DIALOG" open-dialog-params / "OPTIONS.LISTS.GET" options-lists-get-params / "PAUSE" pause-params / "POKE" poke-params / "PRESS.TOOL" press-tool-params / "REFTEXT" reftext-params / "REGISTER" register-params / "REGISTER.ID" register-id-params / "RELREF" relref-params / "RENAME.COMMAND" rename-command-params / "REQUEST" request-params / "RESET.TOOLBAR" reset-toolbar-params / "RESTART" restart-params / "RESULT" result-params / "RESUME" resume-params / "RETURN" return-params / "SAVE.DIALOG" save-dialog-params / "SAVE.TOOLBAR" save-toolbar-params / "SET.NAME" set-name-params / "SET.VALUE" set-value-params / "SHOW.BAR" show-bar-params / "SPELLING.CHECK" spelling-check-params / "STEP" step-params / "TERMINATE" terminate-params / "TEXT.BOX" text-box-params / "UNREGISTER" unregister-params / "VOLATILE" volatile-params / "WHILE" while-params / "WINDOW.TITLE" window-title-params / "WINDOWS" windows-params 47

641absref-params = "(" argument "," ref-argument-expression ")" 48

642active-cell-params = "(" *space ")" 48

643add-bar-params = "(" argument ")" 48

644add-command-params = "(" argument "," argument "," argument ["," argument ["," argument]] ")" 48

645add-menu-params = "(" argument "," argument ["," argument ["," argument]] ")" 48

646add-toolbar-params = "(" argument ["," argument] ")" 48

647app-title-params = "(" argument ")" 48

648argument-params = "(" argument ["," argument ["," ref-argument-expression]] ")" 48

649break-params = "(" *space ")" 48

650call-params = "(" (argument-expression / (argument "," argument *253("," argument))) ")" 48

651caller-params = "(" *space ")" 48

652cancel-key-params = "(" argument ["," ref-argument-expression] ")" 48

653check-command-params = "(" argument "," argument "," argument "," argument ["," argument] ")" 48

654create-object-params = "(" argument "," argument ["," argument ["," argument ["," argument ["," argument ["," argument ["," argument ["," argument ["," argument ["," argument]]]]]]]]] ")" 48

655custom-repeat-params = "(" argument ["," argument ["," argument]] ")" 48

656custom-undo-params = "(" argument ["," argument] ")" 48

657delete-bar-params = "(" argument-expression ")" 48

658delete-command-params = "(" argument "," argument "," argument ["," argument] ")" 48

659delete-menu-params = "(" argument "," argument ["," argument] ")" 48

660delete-toolbar-params = "(" argument-expression ")" 48

661deref-params = "(" ref-argument-expression ")" 48

662dialog-box-params = "(" argument-expression ")" 48

663directory-params = "(" argument ")" 48

664documents-params = "(" argument ["," argument] ")" 48

665echo-params = "(" argument ")" 48

666else-params = "(" *space ")" 48

667else-if-params = "(" argument-expression ")" 49

668enable-command-params = "(" argument "," argument "," argument "," argument ["," argument] ")" 49

669enable-tool-params = "(" argument "," argument "," argument ")" 49

670end-if-params = "(" *space ")" 49

671error-params = "(" argument ["," argument] ")" 49

672evaluate-params = "(" argument-expression ")" 49

673exec-params = "(" (argument-expression / (argument "," argument ["," argument ["," argument]])) ")" 49

674execute-params = "(" argument "," argument ")" 49

675fclose-params = "(" argument-expression ")" 49

676files-params = "(" argument ["," argument] ")" 49

677fopen-params = "(" (argument-expression / (argument "," argument)) ")" 49

678for-params = "(" argument "," argument "," argument ["," argument] ")" 49

679for-cell-params = "(" (argument-expression / (argument "," argument ["," argument])) ")" 49

680formula-convert-params = "(" argument "," argument ["," argument ["," argument ["," argument]]] ")" 49

681fpos-params = "(" (argument-expression / (argument "," argument)) ")" 49

682fread-params = "(" argument "," argument ")" 49

683freadln-params = "(" argument-expression ")" 49

684fsize-params = "(" argument-expression ")" 49

685fwrite-params = "(" argument "," argument ")" 49

686fwriteln-params = "(" argument "," argument ")" 49

687get-bar-params = "(" argument ["," argument ["," argument ["," argument]]] ")" 49

688get-cell-params = "(" (argument-expression / (argument "," ref-argument-expression)) ")" 49

689get-chart-item-params = "(" (argument-expression / (argument "," argument ["," argument])) ")" 49

690get-def-params = "(" (argument-expression / (argument "," argument ["," argument])) ")" 49

691get-document-params = "(" (argument-expression / (argument "," argument)) ")" 49

692get-formula-params = "(" argument-expression ")" 49

693get-link-info-params = "(" argument "," argument ["," argument ["," argument]] ")" 50

694get-movie-params = "(" argument "," argument ["," argument] ")" 50

695get-name-params = "(" (argument-expression / (argument "," argument)) ")" 50