Sebenza "uma" ku-Excel

Phakathi kwemisebenzi eminingi eyenziwa yiMicrosoft Excel esebenza, kufanele ukhethe umsebenzi we- "f ". Lokhu kungenye yalabo basebenzisi lapho abasebenzisi basebenzise khona kaningi lapho benza imisebenzi kulolu hlelo. Masibhekane nalokho lesi sici nokuthi usebenza kanjani nakho.

Ukuchazwa Okujwayelekile Nemisebenzi

"Uma" isici esijwayelekile se-Microsoft Excel. Imisebenzi yayo ifaka ukubheka isimo esithile. Lapho isimo senziwa (iqiniso), bese kuseli, lapho kusetshenziswa khona lo msebenzi ngenani elilodwa, futhi uma kungenziwa (ngamanga) - elinye.

I-syntax yalesi sici imi ngale ndlela elandelayo: "Uma (inkulumo enengqondo; [Umsebenzi uma iqiniso]; [Umsebenzi uma amanga])".

Isibonelo sokusebenzisa "uma"

Manje ake sibheke izibonelo ezithile lapho ifomula nge "Uma" opharetha esetshenziswayo.

1. Sinetafula le-salary. Bonke abesifazane babeka iprimiyamu eya kuma-8 Mashi ngama-ruble angama-1000. Ithebula linekholomu lapho kwachazwa khona phansi. Ngakho-ke, kudingeka sibala abesifazane kusuka ohlwini olunikezwe uhlu nasemigqeni ehambisanayo yokholo "kaMashi ngoMashi 8" ye-1000 ". Ngasikhathi sinye, uma phansi kungahambelani nowesifazane, inani lemicu enjalo kufanele lihambisane ne- "0". Umsebenzi uzothatha lolu hlobo: "Uma (b6 =" abesifazane. ";" 1000 ";" 0 ")". Okungukuthi, lapho umphumela wokuvivinywa "iqiniso" (uma kuvela ukuthi owesifazane onepharamitha "Abesifazane" uthatha umugqa wedatha, khona-ke isimo sokuqala singu- "1000", noma ngabe "kukhona" okusho ukuthi, ngaphandle kokuthi "abesifazane."), ngokulandelana, okokugcina - "0".
2. Singena kule nkulumo esitokisini esiphakeme kunazo zonke, lapho umphumela kufanele uboniswe khona. Ngaphambi kokusho, faka uphawu "=".



3. Ngemuva kwalokho, cindezela inkinobho ethi Enter. Manje njengoba le formula ivela emangqamuzaneni aphansi, mane nje ibeke isikhombisi engxenyeni engezansi kwesokudla leseli eligcwele, chofoza inkinobho yegundane kwesobunxele, ngaphandle kokukhipha, chitha ikhesa kuze kube phansi kwetafula.



4. Ngakho-ke sathola itafula elinekholomu egcwele ngo- "ff uma ".

Isibonelo somsebenzi ngezimo eziningana

Emsebenzini we- "Uma", ungafaka futhi izimo eziningana. Kulesi simo, okunamathiselwe kopharetha oyedwa "uma" kusetshenziswa komunye. Lapho isimo senziwa esitokisini, umphumela ochaziwe uyakhonjiswa, uma isimo singabulawa, umphumela wokuphuma uncike ku-opharetha wesibili.

1. Isibonelo, thatha lonke itafula elifanayo nezinkokhelo zomklomelo ngoMashi 8. Kepha kulokhu, ngokuya ngemibandela, usayizi we-premium kuncike esigabeni sesisebenzi. Abesifazane abanesimo sabasebenzi abaphambili bathola ibhonasi yama-ruble ayi-1000, futhi abasebenzi abasizayo bathola ama-ruble angama-500 kuphela. Ngokwemvelo, amadoda awalutholi lolu hlobo lokukhokha kungakhathalekile isigaba.
2. Isimo sokuqala ukuthi uma isisebenzi siyindoda, khona-ke inani leprimiyamu elitholwe yi-zero. Uma leli nani lingamanga, futhi umsebenzi akayona indoda (okungukuthi, owesifazane), khona-ke ukuhlolwa kwesimo sesibili kuqala. Uma owesifazane ebiza abasebenzi abaphambili, inani elithi "1000" lizokhonjiswa esitokisini, futhi kwelinye icala - "500". Kufomula, kuzobukeka kanjena: "= Uma (b6 =" umyeni. "; 0, 0"; "100") ".
3. Sifaka le nkulumo kwiseli ephezulu yokholomu "kaMashi ngoMashi 8".



4. Njengesikhathi sokugcina, "welula" ifomula phansi.

Isibonelo ngokubulawa kwezimo ezimbili ngasikhathi sinye

Emsebenzini we- "Uma", ungasebenzisa futhi i- "no" opharetha, okuvumela ukuthi ufunde ukwenziwa kwama-Clie kuphela kwezimo ezimbili noma ngaphezulu ngasikhathi sinye.

1. Isibonelo, esimweni sethu, iprimiyamu yangoMashi 8 ngenani lama-ruble angama-1000 anikezwa abesifazane abasebenza ngabasebenzi abaphambili, futhi abamele abantu kanye nabesifazane abasohlwini lwabasebenzi abasizayo abatholwanga. Ngendlela yokuthi inani lamaseli omklomelo ngoMashi 8 lalingu-1000, kuyadingeka ukuhambisana nemibandela emibili: Phansi kungowesifazane, isigaba sabasebenzi singabasebenzi abaphambili. Kuwo wonke amanye amacala, inani elikuleliseli lizoba zero kakhulu. Lokhu kubhalwe yifomula elandelayo: "= Uma (no (B6 =" omkadeli. "; C6 =" abasebenzi abaphambili "); Uyifaka esitokisini.



2. Kopisha inani lefomula kumaseli angezansi, ngokufanayo akhonjiswe ezindleleni ezingenhla.

Isibonelo sokusebenzisa opharetha "noma"

Umsebenzi we- "Uma" ungasebenzisa futhi i- "noma" opharetha. Kusho ukuthi inani leqiniso liyiqiniso uma kwenzeka okungenani eyodwa yezimo eziningana.

1. Ngakho-ke, ake sithi i-premium ngoMashi 8 yi-rubles eyi-1000 kuphela yabesifazane abaphakathi kwabasebenzi abaphambili. Kulokhu, uma isisebenzi siyindoda noma sibhekisela kubasebenzi abasizayo, khona-ke ubukhulu bomklomelo wakhe buzoba zero, futhi ngenye indlela - ama-ruble angu-1000. Njengefomula, kubukeka sengathi lokhu: "= Uma (noma (b6 = umyeni."; C6 = "abasebenzi abasizi"); "0"; "0000. Qopha esitokisini esifanele setafula.



2. "Nweba" imiphumela phansi.

Njengoba ubona, umsebenzi we- "Uma" kungenzeka ube ngumsizi omuhle uma usebenza nedatha ku-Microsoft Excel. Ikuvumela ukuthi ubonise imiphumela ehambelana nemibandela ethile.