Niaj hnub no peb qhia txog cov kev ua ntawm Excel spreadsheet editor, "Yog hais tias." Nws muaj ua nrog cov zajlus kom possibilities ntawm daim ntawv thov. Nws yuav tsum tau ntaus nqi mus rau feem ntau nrov zog thaum lub sij hawm lub lag luam.
Ntsiab nta
Nyob rau hauv Excel, cov mis "Yog hais tias" pab ua txhua hom kev pab raws qib thaum twg koj xav los sib piv ib co ntaub ntawv thiab tau txais ib tug tshwm sim. Cov tshuaj no yuav ua rau nws tau siv branching algorithms, thiab tsim tau ib qhov kev txiav txim tsob ntoo.
piv txwv ntawm qhov kev siv
Cov kev ua zoo li no: = YOG (ua hauj lwm; muaj tseeb tiag; cuav). Tus thawj lub caij - ib zajlus kom qhia. Tej zaum nws yuav yog ib co lus los yog ib tug xov tooj. Piv txwv li, "10" los yog "cais" - yog ib zajlus kom qhia. Qhov no parameter yuav tsum sau. Tseeb - yog tus nqi uas zoo nkaus li raws li ib tug tshwm sim, yog hais tias tus qhia yog muaj tseeb. Pw - cov ntaub ntawv uas yuav tsum tau muab thaum neeg ua hauj lwm yuav tsis muaj tseeb.
Koob pheej ntawm lawv ciaj ciam ntawm ob hlwb
Yuav kom nkag siab txog cov tau khiav dej num ntawm "Yog hais tias" mus Excel, cov piv txwv yog tsuas tsim nyog, thiab ces peb tsiv mus nyob yuav tau xav txog lawv. Tswvcuab rau hauv lub hlwb C1 xam 8. Ntxiv mus, lub thawv rau D1 yog nkag mus nram qab no mis: = YOG (C1 <10; 1; 2). Yog li, qhov kev pab cuam yuav muab los sib piv cov nqi ntawm cov parameter C1 hlwb 10. Thaum nws yog tsawg tshaj li kaum, ib daim teb zoo nkaus li nyob rau hauv qhov chaw nyob chav tsev D1. Txwv tsis pub, lub editor yuav qhia tus xov tooj 2. Xav txog lwm qhov teeb meem. Muaj ib daim ntawv teev me nyuam kawm ntawv thiab lawv cov qhab nias tau nyob rau hauv cov tub ntxhais. Cov no yog cov raws li nram no: 5, 4 thiab 3 thiab 2. Lub tej yam kev mob ntawm qhov teeb meem yuav cov creation rau txhua tus me nyuam kawm ib phau ntawv saib "dhau" los yog "tsis dhau". Nyob rau hauv lwm yam lus, yog hais tias tus menyuam kawm ntawv raug nyob peb thiab mus txog, nws mastered rau lub xeem. Yog hais tias nws tau yog hauv qab no 3 - tus menyuam kawm ntawv tsis dhau. Yuav kom daws tau qhov teeb meem no yog peb sau ntawv rau nram qab no mis: = YOG (C1 <3; "tsis sab laj", "dhau"). Excel yuav pib los sib piv cov kev tshwm sim ntawm txhua tus ntawm cov me nyuam kawm ntawv. Thaum lub Performance index yog tsawg tshaj li peb (ie ob tug) nyob rau hauv qhov chaw uas haum yuav tsum qhia saib "tsis xa." Yog hais tias tau - 3 thiab saum toj no, qhov yuav tsum tau box yuav kos tus cim hais tias cov tub ntxhais kawm ntawv dhau lub xeem. Phau ntawv comments koj yuav tsum nco ntsoov qhia kom meej nyob rau hauv quotes. Raws li xws hauv paus ntsiab lus ntawm tej yam yooj yim zog Excel mis "Yog hais tias". Thaum lub sij hawm nws siv, nws yog tau mus thov xws sib piv tswv: <> =,>, <,> =, <=.
Piv txwv uas tso npe thov lub "LOS SIS" tej yam kev mob "Kuv"
Peb mus txuas ntxiv los xyaum thiab lug tau sai dlua logic ntawm daim ntawv thov. Excel spreadsheet editor muaj nuj nqi "Yog hais tias" yuav muab tag nrho nrog kev sib piv tswv. Cov no yog cov tsis: "LOS SIS", "THIAB". Qhia kom meej qhov yuav tsum tau mob nyob rau hauv Excel: yog hais tias tus neeg kawm tau sib npaug los yog tsawg tshaj li 5, tab sis ntau tshaj 3 yuav tsum tau tso tawm kom pom saib: "hla". Txwv tsis pub - "tsis tau." Yog li ntawd, dhau tsuas yog cov menyuam kawm ntawv uas tau txais tsib thiab plaub. Cov ntaub ntawv uas zoo sib xws ua hauj lwm nyob rau hauv lub rooj editor yuav siv ib tug tshwj xeeb mis. Nws yuav zoo li no: = YOG (THIAB (A1 <= 5; A1> 3); "hla", "tsis muaj"). Yog xav paub ntxiv complex piv txwv muaj xws li cov kev siv ntawm tus "LOS SIS" los yog "THIAB". Yog li ntawd cia saib yuav ua li cas thov tau lub mis nyuj tov rau Excel, Yog hais tias ib tug xov tooj ntawm tej yam kev mob nyob rau hauv lub qhov teeb meem. Ib qho piv txwv ntawm xws ib qho kev qhia: = YOG (LOS YOG (A1 = 5; A1 = 10); 100; 0). Los ntawm no nws hais ntxiv hais tias yog hais tias tus taw qhia nyob rau hauv lub cell A1 yog 5 los yog 10, qhov kev pab cuam qhia txog cov tshwm sim 100 nyob rau hauv lub opposite rooj plaub - 0. yuav siv tau cov no tswv thiab los daws kom tau ntau paub tab. Piv txwv li, lub database yog tsim nyog los mus laij lub tshuav luag nqi uas yuav tsum tau them ntau tshaj li 10,000 tus rubles. Txawm li cas los, lawv tsis them rov qab cov nyiaj txais rau lub hli. Muaj nuj nqi Excel spreadsheet editor, "Yog hais tias" tso cai rau koj yuav tau kos opposite lub duas paub npe "teeb meem neeg". Piv txwv nyob rau hauv cell A1 nyob cov ntaub ntawv qhia lub sij hawm cov nuj nqis (hli). B1 teb qhia tus nqi. Nyob rau hauv cov ntaub ntawv no, cov mis yuav ua tau li nram no: YOG = (I (A1> = 6; B1> 10000); "teeb meem neeg"; ""). Nws li nram no tias yog hais tias ib tug neeg yog pom tias ntais ntawv cov qee cov txheej xwm, cov kev pab cuam yuav qhia nyob rau hauv pem hauv ntej ntawm nws lub npe yam saib. Rau tag nrho lwm cov neeg koom ntawm daim ntawv teev cov uas zoo sib xws cell tseem empty. Xav txog cov piv txwv ntawm cov ntaub ntawv nyob qhov twg qhov teeb meem yog ib qho tseem ceeb. Sau ib tug tsim nyog saib. Raws li ib tug tshwm sim, lub mis yuav zoo li no: = YOG (LOS YOG (A1> = 6; B1> 10000); "ib tug tseem ceeb heev qhov teeb meem no", ""). Nyob rau hauv cov ntaub ntawv no, Yog hais tias qhov kev pab cuam pom ib tug match rau tsawg kawg ib tug ntawm cov tsis (lub sij hawm, nyiaj ntawm cov nuj nqis), tus neeg siv yuav pom cov coj kev ceeb toom. Nyob rau hauv thawj qhov teeb meem no, cov lus "teeb meem neeg" twb muab tsuas yog thaum ob leeg teev tej yam kev mob lawm.
High-theem ua hauj lwm complexity
Muaj nuj nqi Excel spreadsheet editor, "Yog hais tias" yog siv rau bypass lub built-nyob rau hauv kev ua yuam kev thaum faib los ntawm pes tsawg, raws li zoo raws li nyob rau hauv ob peb lwm tus neeg mob. Tus thawj qhov teeb meem no yog qhia los ntawm cov editor li "DIV / 0" thiab yog heev. Nws feem ntau tshwm sim nyob rau hauv tus neeg mob qhov twg cov mis tej zaum yuav tau theej «A / B», nyob rau lub tivthaiv B nyob rau hauv tus neeg lub hlwb yog pes tsawg. Qhov no yuav zam tau los ntawm tus neeg tsav tsheb hu rau tus qhia. Yog li, cov mis yuav tsim nyog los muaj cov nram qab no daim ntawv: YOG = (B1 = 0; 0; A1 / B1). Nws hais ntxiv hais tias yog hais tias tus cell B1 yog lawm ua tus sau nrog tus parameter "zero", lub editor yuav muab ib tug "0", txwv tsis pub faib Excel tivthaiv A1 rau B1 cov ntaub ntawv thiab qhia txog cov kev tshwm sim.
discount
Nyob rau hauv kev xyaum, feem ntau tshwm sim thiab qhov teeb meem no, uas yuav tsum tau los sib tham tom qab. Nws yog hais txog kev xam nyiaj cheb, raws li nyob rau hauv tag nrho cov nqi ntawm cov nyiaj siv rau lub tshaaj ntawm tej yam khoom. Siv nyob rau hauv cov ntaub ntawv no, lub matrix yuav muaj cov nram qab no daim ntawv: tsawg kawg yog 1000 - 0%; 1001-3000 - 3%; 3001-5000 - 5%; ntau tshaj 5001 - 7%. Xav txog cov teeb meem uas muaj ib tug Excel database ntawm cov neeg tuaj saib, raws li zoo raws li cov lus qhia txog tus nqi uas lawv siv rau lub purchase ntawm cov cuab tam. Tam sim no peb yuav tsum tau los mus laij lub luv nqi rau txhua tus neeg. Rau lub hom phiaj no, peb siv cov nram qab qhia :. = YOG (lub A1> = 5001; B1 * 0,93; YOG (A1> = 3001; B1 * 0,95; ..) Lub system cov tshev mis rau tag nrho tus nqi ntawm kev yuav khoom thaum nws tshaj daim duab nyob rau hauv 5001. rubles, yog multiplied by 93 feem pua ntawm tus nqi ntawm cov khoom. nyob rau hauv cov ntaub ntawv ntawm kev kov yeej kev lub cim ntawm 3001 unit, muaj yog ib tug zoo xws li cov nyhuv, tab sis noj mus rau hauv tus account lub 95%. qhov saum toj no cov qauv yuav muab tau yooj yim muab tso rau hauv xyaum. lub ntim ntawm kev muag khoom thiab nyiaj cheb ntsuas los ntawm tus neeg siv.
Kev siv cov piav nta yog ua tau rau cov tshuaj ntawm ntau yam teeb meem. Lub ntsiab theem - kom kev npaj ntawm cov mis tsis tau lub tsis ncaj ncees lawm no. Tam sim no uas koj paub yuav ua li cas siv lub xov tooj rau Excel, Yog hais tias ib tug xov tooj ntawm tej yam kev mob nyob rau hauv lub qhov teeb meem.