excel: àíãëèéñêèé àíàëîã ðóññêèõ ôóíêöèé
íàïèøó êàê øïàðãàëêó ñåáå, ïîñêîëüêó â ñâÿçè ñ ïåðåõîäîì íà OpenOffice ïðèõîäèòñÿ çàìåíÿòü ÑÓÌÌ íà SUM è ò. ä.
Ïîëóæèðíûì âûäåëåíî ðàçäåëåíèå ïî áóêâàì ýòèõ excel-ôóíêöèé
Åñëè ó Âàñ åùå îñòàëñÿ MS Office, òî óäîáíåé áóäåò îòêðûòü ôàéë
C:\Program Files\Microsoft Office\Office1õ\1049\funcs.xls - òàì åñòü âñå ôóíêöèè ñ âîçìîæíîñòüþ ñîðòèðîâêè
ÀÁÑÑÛË ABSREF
ÀÂÒÎ.ÑÒÐÓÊÒÓÐÀ AUTO.OUTLINE
ÀÂÒÎ.ÔÎÐÌÀÒ FORMAT.AUTO
ÀÄÐÅÑ ADDRESS
ÀÊÒÈÂÈÇÈÐÎÂÀÒÜ ACTIVATE
ÀÊÒÈÂÈÇÈÐÎÂÀÒÜ.ÏÐÅÄÛÄÓÙÈÉ ACTIVATE.PREV
ÀÊÒÈÂÈÇÈÐÎÂÀÒÜ.ÏÐÈËÎÆÅÍÈÅ.MICROSOFT APP.ACTIVATE.MICROSOFT
ÀÊÒÈÂÈÇÈÐÎÂÀÒÜ.ÑËÅÄÓÞÙÈÉ ACTIVATE.NEXT
ÀÊÒÈÂÍÀß.ß×ÅÉÊÀ ACTIVE.CELL
ÀÊÒÈÂÍÛÉ.ØÐÈÔÒ.ß×ÅÉÊÈ ACTIVE.CELL.FONT
ÀÑ× SYD
ÀÌÎÐÓÂ AMORLINC
ÀÌÎÐÓÌ AMORDEGRC
ÀÏË SLN
ÀÐÃÓÌÅÍÒ ARGUMENT
ÀÒÐÈÁÓÒÛ ATTRIBUTES
ÁÄÄÈÑÏ DVAR
ÁÄÄÈÑÏÏ DVARP
ÁÄÏÐÎÈÇÂÅÄ DPRODUCT
ÁÄÑÓÌÌ DSUM
ÁÅÑÑÅËÜ.I BESSELI
ÁÅÑÑÅËÜ.J BESSELJ
ÁÅÑÑÅËÜ.K BESSELK
ÁÅÑÑÅËÜ.Y BESSELY
ÁÅÒÀÎÁÐ BETAINV
ÁÅÒÀÐÀÑÏ BETADIST
ÁÑ FV
ÁÇÐÀÑÏÈÑ FVSCHEDULE
ÁÈÇÂËÅ×Ü DGET
ÁÈÍÎÌÐÀÑÏ BINOMDIST
ÁËÎÊÈÐÎÂÀÒÜ.ÂÂÎÄ DISABLE.INPUT
ÁÑ×¨Ò DCOUNT
ÁÑרÒÀ DCOUNTA
ÂÂÎÄ INPUT
ÂÂÎÄ.ÄÀÍÍÛÕ ENTER.DATA
ÂÅÉÁÓËË WEIBULL
ÂÅÐÎßÒÍÎÑÒÜ PROB
ÂÈÄ.ÎÏÐÅÄÅËÈÒÜ VIEW.DEFINE
ÂÈÄ.ÏÎÊÀÇÀÒÜ VIEW.SHOW
ÂÈÄ.ÏÎËÓ×ÈÒÜ VIEW.GET
ÂÈÄ.ÓÄÀËÈÒÜ VIEW.DELETE
ÂÑÄ IRR
ÂÎÇÂÐÀÒ RETURN
ÂÎÇÎÁÍÎÂÈÒÜ RESUME
ÂÎÑÏÐÎÈÇÂÅÑÒÈ.ÇÂÓÊ SOUND.PLAY
ÂÎÑÜÌ.Â.ÄÂ OCT2BIN
ÂÎÑÜÌ.Â.ÄÅÑ OCT2DEC
ÂÎÑÜÌ.Â.ØÅÑÒÍ OCT2HEX
ÂÏÐ VLOOKUP
ÂÏÐÎÊÐÓÒÊÀ VSCROLL
ÂÐÅÌÇÍÀ× TIMEVALUE
ÂÐÅÌß TIME
ÂÑÒÀÂÈÒÜ PASTE
ÂÑÒÀÂÈÒÜ.ÊÀÐÒÀ.ÎÁÚÅÊÒ INSERT.MAP.OBJECT
ÂÑÒÀÂÈÒÜ.ÊÍÎÏÊÓ PASTE.TOOL
ÂÑÒÀÂÈÒÜ.ÊÎÍÅÖ.ÑÒÐÀÍÈÖÛ SET.PAGE.BREAK
ÂÑÒÀÂÈÒÜ.ÐÈÑÓÍÎÊ PASTE.PICTURE
ÂÑÒÀÂÈÒÜ.ÑÂßÇÜ PASTE.LINK
ÂÑÒÀÂÈÒÜ.ÑÂßÇÜ.Ñ.ÐÈÑÓÍÊÎÌ PASTE.PICTURE.LINK
ÂÑÒÐÀÍÈÖÀ VPAGE
ÂÑÒÐÎÊÀ VLINE
ÂÒÎÐÈ×ÍÀß.ÄÈÀÃÐÀÌÌÀ OVERLAY
ÂÒÎÐÈ×ÍÀß.ÄÈÀÃÐÀÌÌÀ.ÒÈÏ OVERLAY.CHART.TYPE
ÂÛÁÎÐ CHOOSE
ÂÛÁÐÀÒÜ.ÝËÅÌÅÍÒ.ÑÏÈÑÊÀ SELECT.LIST.ITEM
ÂÛÂÎÄÈÒÜ.ÍÀ.ÝÊÐÀÍ DISPLAY
ÂÛÄÅËÅÍÈÅ SELECTION
ÂÛÄÅËÈÒÜ SELECT
ÂÛÄÅËÈÒÜ.ÂÑÅ SELECT.ALL
ÂÛÄÅËÈÒÜ.ÄÈÀÃÐÀÌÌÓ SELECT.CHART
ÂÛÄÅËÈÒÜ.ÄÎ.ÊÎÍÖÀ SELECT.END
ÂÛÄÅËÈÒÜ.ÎÁËÀÑÒÜ.ÄÈÀÃÐÀÌÌÛ SELECT.PLOT.AREA
ÂÛÄÅËÈÒÜ.ÏÎÑËÅÄÍÞÞ.ß×ÅÉÊÓ SELECT.LAST.CELL
ÂÛÇÂÀÒÜ CALL
ÂÛÇÛÂÀÞÙÈÉ CALLER
ÂÛÍÅÑÒÈ.ÂÏÅÐÅÄ BRING.TO.FRONT
ÂÛÏÎËÍÈÒÜ RUN
ÂÛÐÀÂÍÈÂÀÍÈÅ ALIGNMENT
ÂÛÐÅÇÀÒÜ CUT
ÂÛÐÎÂÍßÒÜ JUSTIFY
ÂÛÑÂÅÒÈÒÜ.ÒÐÀÑÑÈÐÎÂÙÈÊ TRACER.DISPLAY
ÂÛÑÎÒÀ.ÑÒÐÎÊÈ ROW.HEIGHT
ÂÛÕÎÄ QUIT
ÂÛ×ÈÑËÅÍÈÅ CALCULATION
ÂÛ×ÈÑËÈÒÜ EVALUATE
ÂÛ×ÈÑËÈÒÜ.ÄÎÊÓÌÅÍÒ CALCULATE.DOCUMENT
ÂÛ×ÈÑËÈÒÜ.ÑÅÉ×ÀÑ CALCULATE.NOW
ÃÀËÅÐÅß.ÃÈÑÒÎÃÐÀÌÌÀ GALLERY.COLUMN
ÃÀËÅÐÅß.ÃÐÀÔÈÊ GALLERY.LINE
ÃÀËÅÐÅß.ÊÎËÜÖÅÂÀß GALLERY.DOUGHNUT
ÃÀËÅÐÅß.ÊÐÓÃÎÂÀß GALLERY.PIE
ÃÀËÅÐÅß.ËÈÍÅÉ×ÀÒÀß GALLERY.BAR
ÃÀËÅÐÅß.ÎÁÚÅÌÍÀß.ÃÈÑÒÎÃÐÀÌÌÀ GALLERY.3D.COLUMN
ÃÀËÅÐÅß.ÎÁÚÅÌÍÀß.ÊÐÓÃÎÂÀß GALLERY.3D.PIE
ÃÀËÅÐÅß.ÎÁÚÅÌÍÀß.ËÈÍÅÉ×ÀÒÀß GALLERY.3D.BAR
ÃÀËÅÐÅß.ÎÁÚÅÌÍÀß.ÏÎÂÅÐÕÍÎÑÒÍÀß GALLERY.3D.SURFACE
ÃÀËÅÐÅß.ÎÁÚÅÌÍÀß.Ñ.ÎÁËÀÑÒßÌÈ GALLERY.3D.AREA
ÃÀËÅÐÅß.ÎÁÚÅÌÍÛÉ.ÃÐÀÔÈÊ GALLERY.3D.LINE
ÃÀËÅÐÅß.ÐÀÄÀÐ GALLERY.RADAR
ÃÀËÅÐÅß.Ñ.ÎÁËÀÑÒßÌÈ GALLERY.AREA
ÃÀËÅÐÅß.ÒÎ×ÊÈ GALLERY.SCATTER
ÃÀÌÌÀÍËÎÃ GAMMALN
ÃÀÌÌÀÎÁÐ GAMMAINV
ÃÀÌÌÀÐÀÑÏ GAMMADIST
ÃÈÏÅÐÃÅÎÌÅÒ HYPGEOMDIST
ÃÈÏÅÐÑÑÛËÊÀ HYPERLINK
ÃÎÄ YEAR
ÃÏÐ HLOOKUP
ÃÏÐÎÊÐÓÒÊÀ HSCROLL
ÃÐÀÄÓÑÛ DEGREES
ÃÐÓÏÏÀ GROUP
ÃÐÓÏÏÈÐÎÂÀÒÜ.ÏÎËß.ÑÂÎÄÍÎÉ PIVOT.FIELD.GROUP
ÃÑÒÐÀÍÈÖÀ HPAGE
ÃÑÒÐÎÊÀ HLINE
December 7th, 2007 at 17:03
Òî ÷òî íàäî!
Ñïàñèáî! Ïîëåçíî è íåîáõîäèìî!
ÂÑÅÌ! èñïîëüçóéòå ÂÑÅÃÄÀ ÒÎËÜÊÎ àíãëèéñêîå íàïèñàíèå ôóíêöèé!
December 8th, 2007 at 17:54
(ñìóùåííî êîëóïàþ ïàðêåò áîòèíêîì)