Ifomula ka "ukuhlukanisa" ukuba-Excel - izimiso eziyisisekelo futhi izibonelo yokusetshenziswa

Abasebenzisi ejwayele ukusebenza amafomula isicelo-spreadsheet "Excel" kusukela "Microsoft", ngezinye izikhathi uzama ukuthola umsebenzi ngomumo eyenziwe yokuhlukanisa inombolo eyodwa ngomunye. Kodwa akukho umsebenzi onjalo, bese usebenzisa ikholoni njengoba kungaqali - kuwukuthi "Excel" kuhloswe ukuba ubheke uhla. Ifomula besigaba kuya Excel - kungcono nje uphawu udwi (/).

Indlela ukuhlukanisa inombolo eyodwa ngomunye

Esikhathini "Excel" encwadini lokusebenzela uthayiphe ezitokisini ezihlukene noma iziphi izinombolo ezimbili. Bazokusiza ukubhekana indlela yokwenza ifomula division Excel. Khona-ke iseli uhlobo khulula ukuqala ifomula (alinganayo =) bese ukhetha iseli kuqala nge sihlukaniswe. Okulandelayo uhlobo uphawu ikufomula Excel - udwi - bese ukhetha iseli nge isihlukanisi.

Ihlangene, lapho sizama cell division, okuqukethwe kuyo 0, "Excel" ubonisa Iphutha elifanele # UKWAHLUKANISWA / 0!.

Okubalulekile! Excel ikuvumela ukuba wabelane nabanye iyiphi inombolo ngayinye, kuhlanganise usuku. Kodwa uma uzama ukwenza ukwehlukaniswa amaseli ukuthi nombhalo, uzothola Iphutha "# VALUE!", Kukhona value okungalungile.

Ukuhlukaniswa kosuku

Kuyathakazelisa kakhulu ukwabelana nezinsuku. Zama ukwabelana "01/01/2017" ukuze "01.01.2016". Ucabanga singazange siphumelele? Lena akuyona ngakho. Iqiniso lokuthi "Excel" sizoguqula ngokuzenzakalelayo bonke izinsuku eziningi, ubala izinsuku langemva selokhu-January 1, 1900. Usuku "01.01.1900" - inombolo 1, "01/02/1900" - 2. Ungakwazi kalula hlola lokhu ngokuguqula format esitokisini izinsuku eshiwo nge "Usuku" format ngefomethi "ezinombolo". Ngakho, ngo-January 1, 2017 - le nombolo 42736, kuba izinsuku eziningi kangaka sele idlulile solo ukuthi ngalo lolo suku futhi ngenyanga ngo-1900. Ngakho-ke, ngokuyihlukanisa owodwa usuku komunye, singaluthola yalokho ethize.

Kunengqondo ukuthi ungaba hhayi kuphela usuku nosuku, kodwa yisiphi isibalo usuku okuphambene nalokho. Njengoba formula "ukuhlukanisa" Excel namanje ukwethula usuku lwakho enombolweni. Futhi kungenzeka isebenze ngendlela oyithandayo.

Ithebula ukuqoqwa "Excel"

Yakha itafula "Excel", a A2 cell: A6 ukubeka izinombolo ezokwenza ukwabelana (3, 7, 9, 12, 15), futhi amaseli B1: E1 - inombolo bazocula division (1, 2, 3 4).

Ukudala umnyango we etafuleni, kubalulekile ukukhumbula mayelana izinkomba ngokuphelele futhi isihlobo ku "Excel". Ifomula sesigaba Excel ekulungiseleleni itafula onjena ukulisebenzisa izinkomba okuxubile. Ngakho ukuthi amakheli cell lapho ukukopisha akuyona sigudluke, kubalulekile ukuba ulungise kunombolo ikheli idividendi ikholomu, kanye ehlukanisayo - Inambalayini. Ngakho, faka iseli B2 ifomula «= $ A2 / B $ 1" futhi idonsele ngokusebenzisa string? bese wonke etafuleni. Ithebula egcwele idatha. Manje sukuma kunoma iyiphi iseli, isibonelo, kwi D5. ifomula Its okulandelayo: «= $ A5 / D $ 1". Senze konke kulungile.

Division nge okusele

Uma wenza ukwahlukana, ezimweni eziningi esizitholayo inombolo wamaqhuzu. Ukuze lula bezibona izinombolo ezinjalo uku "Excel" amaphuzu amabili abalulekile.

Iseli, eyayibhalwe yalokho, okuzenzakalelayo "Okujwayelekile" format. Uma uye kuthebhu "Ekhaya" ku "Inombolo" sigaba, kungenzeka kusuka ohlwini okwehliswayo ukhethe ifomethi ushintsho "Okunye nezakhiwo inombolo" bese usetha ifomethi "ezinombolo". Ngalokhu format singasetshenziswa eyabelwe inombolo cell yezindawo zedesimali. Ngakho, sokuhlukanisa 7/3 sivame ukubona inombolo 2,333333333, futhi ngosizo ngokunemba umkhawulo izindawo ezintathu idesimali, izobukeka 2.333. Yini uzovuma, kuyinto ehluke elula.

I "Excel" has imisebenzi ezimbili ezihlukene ukuze uthole quotient futhi okusele division. Zibizwa ngokuthi "Okuyimfihlo" futhi "Balance" futhi bobabili ukuthatha zimpikiswano ezimbili saziso - the numerator kanye Iningi. Sizokwenza ukuthi uqonde kabanzi nabo.

Faka "Excel" izinombolo ezimbili - 7 no-3 (D9, futhi D10 kuseli kulokhu), kanye nelungelo wabo - ifomula:

Njengoba sibona, the quotient ilingana ezimbili, lezi zinsalela ziyavezwa - 1. iyiphi iseli ezingenalutho, faka ifomula:

= E9 & "" & E10 & "/" & D10

Lapha ampersand kusiza unamathisele okuqukethwe okuqukethwe iseli kwenye umbhalo.

Waba yini umphumela walesi Ifomula okulandelayo: 2 1/3 - amabili iphuzu eyodwa.

Njengoba ubona, ifomula sesigaba Excel akuyona into enkulu. Into esemqoka okufanele uyikhumbule ukuthi amafomula ukubala "Excel" isebenzisa imithetho ejwayelekile wezibalo.