txheem
Nag hmo hauv marathon 30 Excel ua haujlwm hauv 30 hnub peb tau ntxuav cov chaw ntxiv uas siv cov haujlwm TRIM (CIMATE) thiab tseem ua kom paub tseeb tias nws yuav tsis hloov cov calories tswj hauv peb cov ntawv qhia zaub mov.
Hnub plaub ntawm marathon peb yuav mob siab rau txoj kev kawm ntawm txoj haujlwm INFO (POV). Excel pab ceeb toom peb kom ceev faj nrog txoj haujlwm no, txwv tsis pub koj tuaj yeem muab cov ntaub ntawv ntiag tug rau lwm tus neeg siv!
Yog li cia peb saib cov haujlwm siv INFO (XEEM) thiab xav txog ob peb yam piv txwv. Yog tias koj muaj lus qhia ntxiv txog qhov no lossis lwm yam kev siv, thov qhia rau lawv hauv cov lus. Thiab khaws koj cov secrets!
Function 04: INFO
muaj nuj nqi INFO (INFORM) qhia cov ntaub ntawv hais txog qhov chaw ua haujlwm tam sim no.
Yuav siv INFO function li cas?
muaj nuj nqi INFO (INFORM) tuaj yeem qhia cov ntaub ntawv hauv qab no txog Excel:
- Microsoft Excel version.
- Tus naj npawb ntawm cov nplooj ntawv Excel ua haujlwm.
- Txoj kev suav tam sim no.
Hauv Excel versions dhau los, koj tuaj yeem tau txais cov ntaub ntawv hais txog cov peev txheej nco, tab sis cov lus sib cav no tsis muaj kev txhawb nqa ntxiv lawm.
Syntax INFO (INFORM)
muaj nuj nqi INFO (INFORM) muaj cov syntax hauv qab no:
INFO(type_text)
ИНФОРМ(тип_информации)
Type_text (information_type) yog ib qho kev sib cav uas qhia txog cov ntaub ntawv dab tsi los khaws. Cov txiaj ntsig hauv qab no tuaj yeem siv los ua kev sib cav:
- directory (DIRECTORY) - cov npe tam sim no lossis cov ntawv tais ceev tseg.
- cov nymphs (NUM FILES) - tus naj npawb ntawm cov nplooj ntawv nquag.
- keeb kwm (SOURCE) yog qhov kev siv ntawm tes kiag li nyob rau sab laug sab laug ntawm lub vijtsam.
- osversion (VERSIONOS) - version ntawm lub operating system.
- recalc (RECALCULATE) - txoj kev suav rov qab tam sim no: "Automatically" lossis "Manually".
- tso tawm (VERSION) - Microsoft Excel version.
- system (SYSTEM) - lub npe ntawm lub operating system: "pcdos" lossis "mac".
Traps INFO (INFORM)
Microsoft Excel Pab tau ceeb toom tias muaj nuj nqi INFO (INFORM) yuav tsum tau siv nrog ceev faj vim nws yuav nthuav tawm cov ntaub ntawv rhiab rau lwm tus neeg siv. Koj tsis xav muab rau lwm tus neeg siv tag nrho txoj hauv kev rau koj phau ntawv, koj puas yog? Yog li thaum xa cov ntaub ntawv Excel rau ib tus neeg, xyuas kom koj tshem tawm cov ntaub ntawv koj tsis xav qhia.
Piv txwv 1: Microsoft Excel version
Siv lub luag haujlwm INFO (INFORM) nrog kev sib cav tso tawm (VERSION) Koj tuaj yeem tau txais cov ntaub ntawv Excel version. Cov txiaj ntsig yog nyob rau hauv cov ntawv nyeem, tsis yog tus lej. Cov screenshot qhia hauv qab no yog coj hauv Excel 2010, yog li cov txiaj ntsig yuav yog 14.0.
=INFO("release")
=ИНФОРМ("ВЕРСИЯ")
Koj tuaj yeem siv qhov tshwm sim los tso saib cov lus qhia txog version ntawm Excel.
=IF(C2+0<14,"Пора обновляться","Последняя версия")
=ЕСЛИ(C2+0<14;"Пора обновляться";"Последняя версия")
Piv txwv 2: Number of Active Sheets
Siv kev sib cav cov nymphs (NUMFILE) muaj nuj nqi INFO (INFORM) tuaj yeem qhia tus lej ntawm cov nplooj ntawv nquag hauv txhua phau ntawv Excel qhib. Tus lej no suav nrog cov ntawv zais, nplooj ntawv hauv phau ntawv ua haujlwm zais, thiab cov nplooj ntawv hauv add-ons.
Hauv qhov piv txwv hauv qab no, Excel phau ntawv ua haujlwm nrog tsib nplooj ntawv tau qhib thiab lub plug-in uas muaj ob nplooj ntawv tab tom khiav. Tag nrho cov ntawv xa rov qab los ntawm kev ua haujlwm INFO (INFORM), yuav muab sib npaug rau xya.
=INFO("numfile")
=ИНФОРМ("ЧИСЛОФАЙЛОВ")
Piv txwv 3: Txoj kev suav rov qab tam sim no
Es tsis txhob nkag mus rau qhov kev sib cav type_text (information_type) rau kev ua haujlwm INFO (INFO) Koj tuaj yeem xa mus rau ib lub xovtooj ntawm tes uas muaj ib qho ntawm cov nqi sib cav. Hauv qhov piv txwv hauv qab no, cell B3 muaj cov npe poob thiab cov haujlwm INFO (INFORM) hais txog lub cell no.
=INFO(B3)
=ИНФОРМ(B3)
Thaum xaiv cov npe recalc (RECALCULATE), qhov tshwm sim qhia tau hais tias txoj kev suav rov qab tam sim no Txav.
