Yuav Ua Li Cas Siv IF Function hauv Spreadsheets: 10 Kauj Ruam

Cov txheej txheem:

Yuav Ua Li Cas Siv IF Function hauv Spreadsheets: 10 Kauj Ruam
Yuav Ua Li Cas Siv IF Function hauv Spreadsheets: 10 Kauj Ruam

Video: Yuav Ua Li Cas Siv IF Function hauv Spreadsheets: 10 Kauj Ruam

Video: Yuav Ua Li Cas Siv IF Function hauv Spreadsheets: 10 Kauj Ruam
Video: Sib Hawm Dhau (Time Passed) Music Video by: Deeda/Dib Xwb 2024, Plaub Hlis Ntuj
Anonim

Kawm paub IF txoj haujlwm yog thawj kauj ruam kom nkag siab siv cov haujlwm siab hauv daim ntawv nthuav qhia xws li Microsoft Excel, spreadsheets.google.com, OpenOffice.org Calc, KS กระจาย, iNumbers lossis Gnumeric. Cov lus IF yog qhov haujlwm muaj txiaj ntsig zoo los siv hauv Excel. Nws ntsuas los txiav txim siab yog tias muaj qee yam xwm txheej hauv daim ntawv teev npe muaj tseeb lossis tsis tseeb los ntawm kev sib piv tus nqi rau ntawm lub xovtooj ntawm tes rau tus neeg siv teeb tsa, thiab hloov nws nrog cov tswv yim uas tus neeg siv teeb tsa ib yam. Nws suab nyuab, tab sis tsim daim ntawv IF yog tsis nyuaj.

Cov kauj ruam

Siv IF Function hauv Spreadsheets Kauj Ruam 1
Siv IF Function hauv Spreadsheets Kauj Ruam 1

Kauj Ruam 1. Xaiv lub cell

Xaiv lub xov tooj ntawm tes uas koj xav nkag mus rau txoj haujlwm (feem ntau yog lub xovtooj khoob), piv txwv li B2.

Siv IF Function hauv Spreadsheets Kauj Ruam 2
Siv IF Function hauv Spreadsheets Kauj Ruam 2

Kauj Ruam 2. Sau qhov kos npe sib npaug

Thawj qhov koj yuav tsum tau ua txhawm rau ntaus lub luag haujlwm yog ntaus cim sib npaug (=).

Siv IF Function hauv Spreadsheets Kauj Ruam 3
Siv IF Function hauv Spreadsheets Kauj Ruam 3

Kauj Ruam 3. Ntaus IF

Siv IF Function hauv Spreadsheets Kauj Ruam 4
Siv IF Function hauv Spreadsheets Kauj Ruam 4

Kauj Ruam 4. Ntxiv cov kab ntawv qhib

Piv txwv = YOG (.

Siv IF Function hauv Spreadsheets Kauj Ruam 5
Siv IF Function hauv Spreadsheets Kauj Ruam 5

Kauj Ruam 5. Xaiv qhov twg cov txiaj ntsig yuav tshwm

Ua piv txwv, nyem rau ntawm cell A2.

Siv IF Function hauv Spreadsheets Step 6
Siv IF Function hauv Spreadsheets Step 6

Kauj Ruam 6. Ntaus nqe lus tom qab ua tus cim

Piv txwv = YOG (A2> 100, (Nco tseg: Hauv qee yam lus, piv txwv li Dutch, koj yuav tsum siv tus lej ";" tsis txhob siv tus lej ntawm txhua nqe lus. Piv txwv = YOG (A2> 100;

Siv IF Function hauv Spreadsheets Kauj Ruam 7
Siv IF Function hauv Spreadsheets Kauj Ruam 7

Kauj Ruam 7. Ntaus qhov xwm txheej yog tias nqe lus txaus siab

Ua qhov no ua raws tus lej cim. Piv txwv = IF (A2> 100, "A yog tshaj 100",.

Siv IF Function hauv Spreadsheets Kauj Ruam 8
Siv IF Function hauv Spreadsheets Kauj Ruam 8

Kauj Ruam 8. Ntaus qhov xwm txheej yog tias nqe lus tsis txaus siab

Piv txwv = YOG (A2> 100, "A ntau dua 100", "A tsawg dua lossis sib npaug 100".

Siv IF Function hauv Spreadsheets Kauj Ruam 9
Siv IF Function hauv Spreadsheets Kauj Ruam 9

Kauj Ruam 9. Kaw kab zauv

Piv txwv = YOG (A2> 100, "A ntau dua 100", "A tsawg dua lossis sib npaug rau 100").

Siv IF Function hauv Spreadsheets Step 10
Siv IF Function hauv Spreadsheets Step 10

Kauj Ruam 10. Ua kom tiav cov mis

Nias Rov Qab (lossis nyem lub npov zuam) kom ua tiav cov mis.

Yees duab - Los ntawm kev siv qhov kev pabcuam no, qee cov ntaub ntawv yuav raug muab qhia rau YouTube

Lub tswv yim

  • Nested IF cov haujlwm muaj ntau dua thiab muaj kev ua haujlwm ntau dua.
  • Cov txheej txheem raws li txoj cai tuaj yeem koom nrog IF ua haujlwm.
  • Cov txiaj ntsig tau teev tseg yog piv txwv. Koj tuaj yeem teeb tsa qhov tseem ceeb uas koj xav tau rau koj daim ntawv IF.

Pom zoo:

Yuav Ua Li Cas Siv Lub Tsheb Siv Hauv Facebook Marketplace: 14 Kauj Ruam

Yuav Ua Li Cas Siv Lub Tsheb Siv Hauv Facebook Marketplace: 14 Kauj Ruam

Cov txheej txheem no suav nrog cov txheej txheem ntawm kev nrhiav thiab yuav lub tsheb siv nrog kev siv tshuab hauv Facebook kev lag luam, cov cuab yeej muaj txiaj ntsig rau kev yuav ntau yam khoom thaum siv ua tib zoo. Cov kauj ruam Ntu 1 ntawm 5:

Yuav Ua Li Cas Siv Cov Kauj Ruam Sau Hauv Windows: 5 Kauj Ruam (nrog Duab)

Yuav Ua Li Cas Siv Cov Kauj Ruam Sau Hauv Windows: 5 Kauj Ruam (nrog Duab)

Puas yog koj tus phooj ywg geeky uas txhua tus neeg hu thaum lawv xav tau kev pab PC? Nyeem kab lus no yuav hloov txoj kev koj muab rau lawv cov lus qhia. Ib qho tseem ceeb uas tseem tsis tau zais ntawm Windows yog nws cov ntawv kaw suab, ib qho app uas sau koj cov dej num ib zaug koj tsoo lub pob kaw thiab tsim cov nplooj ntawv qhia, nrog cov ntawv thiab cov duab, kom piav qhia koj tau ua dab tsi.

Yuav Siv Google Spreadsheets li cas: 14 Kauj Ruam (nrog Duab)

Yuav Siv Google Spreadsheets li cas: 14 Kauj Ruam (nrog Duab)

Thaum Lub Rau Hli 6, 2006, Google tau tshaj tawm cov khoom lag luam spreadsheets raws li "kev sim txwv" rau cov neeg siv tsawg. Qhov kev sim txwv tsis pub nyob ib puag ncig, thiab Google Sheets tam sim no tau siv dav ua qhov tshwj xeeb ntawm Google Docs.

Yuav txheeb li cas los ntawm Ntau Kab hauv Google Spreadsheets: 7 Kauj Ruam

Yuav txheeb li cas los ntawm Ntau Kab hauv Google Spreadsheets: 7 Kauj Ruam

Qhov wikiHow no qhia koj yuav txheeb ob lossis ntau kab ntawm cov ntaub ntawv raws li ib kab hauv Google Cov Ntawv. Cov kauj ruam Kauj Ruam 1. Qhib koj daim ntawv Google Mus rau https://sheets.google.com hauv koj tus browser, tom qab ntawd nyem rau koj daim ntawv teev npe.

Yuav Ua Li Cas Siv Islogical Function hauv Excel: 10 Kauj Ruam (nrog Duab)

Yuav Ua Li Cas Siv Islogical Function hauv Excel: 10 Kauj Ruam (nrog Duab)

Qhov wikiHow no qhia koj li cas txhawm rau txheeb xyuas qhov muaj txiaj ntsig (xws li muaj tseeb lossis tsis tseeb) hauv Excel siv ISLOGICAL ua haujlwm. Cov kauj ruam Kauj Ruam 1. Qhib Microsoft Excel Yog tias koj siv Windows, koj yuav pom nws hauv Windows cov ntawv qhia hauv qab "