Ukuqhathanisa Umqhubi

I-Excel ne-Google Spreadsheet AbaSebenzi Abayisithupha Ukuqhathanisa

Ama-operators, ngokujwayelekile, angamatshwayo asetshenziswa emafomulini ukuze acacise uhlobo lokubala oluzokwenziwa.

U-opharetha wokuqhathanisa, njengoba igama lakhe liphakamisa, wenza ukufaniswa phakathi kwamanani amabili kwifomula futhi umphumela walokho kuqhathaniswa kuphela ungaba yi-TRUE noma FALSE.

Ama-Operators ayisithupha

Njengoba kuboniswe esithombeni ngenhla, kuneziphakeli eziyisithupha zokuqhathanisa ezisetshenziselwa izinhlelo zespredishithi njenge-Excel nama-Google Spreadsheets.

Lawa ma-operators asetshenziselwa ukuhlola izimo ezifana nalezi:

• ukulingana kwamanani, njenge-5 = 5,
• ukungalingani kwamanani,
  • njenge-4 <> 5 (ayilingani)
  • noma 5> = 4 (enkulu kunazo zonke noma elinganayo).

Sebenzisa kumafomula eselula

I-Excel iguquguquka kakhulu ngendlela lezi opharetha zokuqhathanisa ezingasetshenziswa ngayo. Isibonelo, ungabasebenzisa ukuqhathanisa amaseli amabili , noma uqhathanise imiphumela yefomula elilodwa noma ngaphezulu . Ngokwesibonelo:

• = A1 = A2
• = A1 = (A2 * 5)
• = (A1 * 10) <= (A2 / 5)

Njengoba lezi zibonelo ziphakamisa, ungazifakela ngqo esitokisini ku-Excel bese u-Excel ubala imiphumela yefomula njengoba nje eyokwenza nanoma iyiphi ifomula.

Ngezifomula, i-Excel izobuya njalo i-TRUE noma i-FALSE njengomphumela esitokisini.

Opharetha abanemibandela angasetshenziswa kumfomula oqhathanisa amanani kumaseli amabili kushidi lokusebenzela .

Futhi, umphumela waloluhlobo lwefomula luzobe lube yi-TRUE noma FALSE.

Isibonelo, uma iseli A1 iqukethe inombolo 23 kanye ne-A2 yeseli iqukethe inombolo engu-32, ifomu = A2> A1 izobuyisa umphumela we-TRUE.

I-formula = A1> A2, ngakolunye uhlangothi, izobuyisela umphumela we-FALSE.

Sebenzisa emaZitatimendeni ezinemibandela

Ama-opharetha wokuqhathanisa asetshenziselwa izitatimende ezinemibandela, njengokuthi i-IF function i-argument yokuhlola ehlakaniphile yokunquma ukulingana noma umehluko phakathi kwamagugu amabili noma ama-operands.

Ukuhlolwa okunengqondo kungaba ukuqhathaniswa phakathi kwezinkomba ezimbili zamaseli njenge:

A3> B3

Noma ukuhlolwa okunengqondo kungaba ukufaniswa phakathi kwereferensi yeseli kanye nenani elinqunyiwe njenge:

I-C4 <= 100

Endabeni yomsebenzi we-IF, noma ngabe ingxabano yokuhlolwa kwelogi evele ihlole ukulinganisa njengeQINISO noma FALSE, umsebenzi we-IF awuvame ukukhombisa le miphumela kumaseli okusebenzela.

Esikhundleni salokho, uma isimo esivivinywa singu-TRUE, umsebenzi wenza isenzo esibhalwe ku- Value_if_kright argument .

Uma, ngakolunye uhlangothi, isimo esivivinywa singu-FALSE, isenzo esibhalwe ku- Value_if_false argument senziwa esikhundleni.

Ngokwesibonelo:

= IF (A1> 100, "Ngaphezu kwekhulu", "Ikhulu noma ngaphansi")

Isivivinyo sama-logic kule nqubo ye-IF isetshenziselwa ukunquma ukuthi inani eliqukethwe esitokisini A1 likhulu kunekhulu.

Uma lesi simo siyiqiniso (inombolo e-A1 ingaphezulu kuka-100), umyalezo wokuqala wombhalo Ngaphezu kwekhulu uboniswa esitokisini lapho ifomula ihlala khona.

Uma lesi simo si-FALSE (inombolo e-A1 ingaphansi noma ilingana no-100), umlayezo wesibili I- 100 noma ngaphansi iboniswa kuseli eliqukethe ifomula.

Sebenzisa ku-Macros

Ama-opharetha wokuqhathanisa asetshenziselwa izitatimende ezinemibandela kuma- macros e-Excel, ikakhulukazi ezitsheni, lapho umphumela wokuqhathanisa ukhetha ukuthi ukubulawa kufanele kuqhubeke yini.