Computers, Software
Yuav ua li cas yuav ua rau tus npaug nyob rau hauv excel
Haib spreadsheet "Microsoft Excel" yooj yim yuav muab tej ntawm koj tus xov tooj thiab yog hom twg. Thaum nws yuav ua tau yeej yuav pab tau nyob rau hauv no li cas? Muaj ntau ntau lub ntsiab:
- Txhais tes yog tsis yog ib tug tswvyim.
- Muab loj yog hom twg ntawm cov zauv, thiab koj xav pom dab tsi zoo ntawm tus xov tooj yog muab kev koom tes, thiab tej zaum txawm yuav hloov tau ib txhia ntawm lawv (nyob rau hauv tus txheej txheem laij leb zog tsis muaj qhov yuav tsum tau mus pib lub kab dua txuag lub xam).
- Npaug - tsuas yog ib feem ntawm ib tug puas ntawm lub mis.
Raws li koj tau pom, lub npaug rau Excel - tshaj plaws kiag li tsis superfluous. Yog tsis muaj sib npaug ua hauj lwm tsis tau ua yuav luag tsis muaj ib tug formula.
Variants txawj nyob rau hauv "Excel"
"Excel" tso cai rau koj mus muab txhua lwm yam:
- Cov naj npawb xov tooj (zoo, tsis zoo, integer, fractional).
- Cov xov tooj ntawm cov hlwb.
- Yog hom twg ntawm cov zauv.
- Boolean qhov tseem ceeb
Yuav ua li cas mus ua npaug? Cov mis ntawm kev ua lej khu nyob rau hauv Excel pib nrog cov "sib npaug" kos npe rau (=). Raws li nyob rau hauv tej mis hereinafter qhia ib tug tom qab lwm tus xov tooj (los yog siv cell uas muaj lawv) kev cob cog rua cim "lub hnub qub" (*). Xws li ib tug noj mis nyuj tov yuav raws li nram no: "= 0.22 * 16 -5 *" (thaum khoo tej xov tooj) los yog «= G4 * I5» (raws li cov lus thaum lub teev ntawm tes ua tim khawv). Qhov no yog thawj version ntawm lub npaug.
npaug mis nyob rau hauv Excel yuav muab sau tseg siv lub built-in "ua" muaj nuj nqi:
kev ua npe | cov lus sib cav | piav qhia |
ua | Number / ntau 1; Number / ntau 2; ... Number / ntau 255; | Cov tshwm sim ntawm cov nuj nqi - cov khoom ntawm cov lus. Tag nrho cov 255 tej zaum yuav siv rau tej xov tooj los yog hom twg (luaj li cas ntawm cov kab yog tsis tas). |
Qhov kom zoo dua ntawm kev siv no muaj nuj nqi rau nws yog ua npaug rau Excel - tau txawj los ntawm txhua lwm yam, tsis tsuas xov tooj, tab sis kuj bands.
Peb tam sim no xav txog cov kev piv txwv.
Npaug los ntawm ib tug "lub hnub qub"
Sim rau ib tug ntawv ntawm phau ntawv "Excel" ua raws li cov piv txwv:
tus nqi 1 | nqi 2 | mis | tshwm sim | |
A | B | C | D | |
2 | 2 | 3 | = A2 * B2 | 6 |
3 | 0.7 | -6 | = A3 * B3 | -4,2 |
4 | QHOV TSEEB | QHOV TSEEB | = A4 * B4 | 1 |
5 | QHOV TSEEB | cuav | = A5 * B5 | 0 |
6 | cuav | cuav | = A6 * B6 | 0 |
Nrog lawv, koj yuav pom tias ua lub npaug nyob rau hauv Excel yog ib qho yooj yim. Nco ntsoov tias cov kev tshwm sim ntawm lub npaug logic qhov tseem ceeb ua 0 (cuav) los yog 1 (tseeb).
Lub tsuas drawback ntawm no txoj kev ntawm kev ua lej khu - uas ntau yam ntawm tus xov tooj raws li ib tug sib cav, nws yuav tsis tau txais. Tej zaum ib tug tshaj plaws, uas yog txaus ntawm cov neeg siv txhais qhov chaw nyob rau thaum xaus ntawm lub thib ob kaum tus xov tooj los yog cell, txav, thiab interleaved nyob rau hauv kev txiav txim cim "cim."
Tib txoj kev nyob ib ncig ntawm no drawback yog siv "ua" muaj nuj nqi.
Npaug siv "ua" muaj nuj nqi
Xav txog yuav ua li cas yuav ua li cas npaug nyob rau hauv Excel siv lub built-in muaj nuj nqi.
Phau ntawv "Excel" los ua ib tug zoo xws li cov phaj thiab saib rau ntawm nws lub piv txwv. Nyob rau hauv ib kem ua ntau qhov tseem ceeb nyob rau hauv lwm kem kuj ua ob peb lub ntsiab. Sim mus thov tus muaj nuj nqi "ua" koj bands, thiab ua npaug los ntawm txhais tes ntawm cov kos npe rau "lub hnub qub".
H | kuv | J | K | |
Ntau 1 | Ntau 2 | tshwm sim | mis | |
12 | 2 | 6 | 9,378,270.72 | Ua = (H12: H16; I12: I16) |
13 | 7 | 14,2 | 9,378,270.72 | Ua = (H12: I16) |
14 | 5 | -2,7 | 9,378,270.72 | = H12 * H13 * H14 * H15 * H16 * I12 * I13 * I14 * I15 * I16 |
15 | 0,26 | 4 | ||
16 | -10 | 56 |
Nyob rau hauv cov kem "Formula" ntawm cov lus no kom meej meej qhia tau hais tias yog hais tias tus nqi yog hom twg yog nyob ze, lawv muaj peev xwm yuav siv tau raws li ib tug ntau yam. Tsis tas li ntawd nyob rau hauv lub rooj koj yuav pom hais tias tus muaj nuj nqi "ua" kom muab tag nrho cov yog hom twg, thiab tau cov kev tshwm sim tib txoj kev raws li yog hais tias peb twb nyob rau ib txhais tes multiplies tus nqi ntawm cov hlwb. Raws li koj tau pom, lub npaug rau Excel - yog ib tug snap.
Nthuav fact! Sim ib tus nqi yog tam sim no muab tshem tawm los ntawm tej cell, ib feem ntawm cov ntau yam, nchuav hlwb yuav li lawm. Koj yuav pom tau tias nyob rau tib lub sij hawm ua muaj nuj nqi mus ua ib tug muab xam, tsuas tso ib qho kev npliag cell. Thiab ntawm no yog cov kev tshwm sim ntawm "phau ntawv" npaug tig mus rau zero. Qhov no yog tsis tau lwm cov kom zoo dua ntawm ua-nyob rau hauv kev xaiv kom muab "cim" - nws tsis txais dawb paug hlwb li pes tsawg, nws cia li tawm lawv los ntawm lub xam.
Muaj tej lub sij hawm thaum suav yog ua rau cov plurality ntawm kev ua hauj lwm los xij phau ntawv, thiab lub resulting ntawv yog muab mis, muaj cov khoom ntawm qhov tseem ceeb ntawm cov lwm yam los xij. Yog hais tias muaj ib tug ntawm lawv yuav tau npliag, ib tug yooj yim npaug ntawm cov "hnub qub" tig tag nrho koj tau nyob rau hauv xoom.
Los ntawm no peb yuav xaus uas cov kev tswj ntawm complex suav rau ntau los xij yog zoo dua siv lub muaj nuj nqi "ua" raws li ib tug tseem ceeb.
npaug rooj
Saib thaum kawg, ua ib tug sib npaug rooj nyob rau hauv Excel. Nws yog ib qho yooj yim.
A | B | C | D | E | |
1 | 2 | 4 | 6 | 8 | |
2 | 3 | = $ A2 * B $ 1 | 12 | 18 | 24 |
3 | 5 | 10 | 20 | 30 | 40 |
4 | 7 | 14 | 28 | 42 | 56 |
5 | 9 | 18 | 36 | 54 | = $ A5 * E $ 1 |
Nyob rau hauv lub lig kev cai ntawm tus qauv ua lej khu rooj muaj xws li ib tug sab ntawm ib tug txheej ntawm tus xov tooj nyob rau hauv ib tug kab - lub lwm yam. Yuav tsum tau luam cov mis, nws yog tsim nyog los siv mixed mus - mus txhim kho los ntawm tus kos npe rau "duas" ($) kem tooj xws li los ntawm ntsug cov ntaub ntawv kab thiab kab rov tav kom muaj cov ntaub ntawv '= A2 * $ B $ 1 ".
Similar articles
Trending Now