Uma uke wasebenza ku-Excel, kungenzeka ukuthi uke wayisebenzisa ukuze ugcine futhi wenze izibalo ezinhlotsheni ezihlukahlukene zedatha, njengezinombolo eziphelele, amadesimali, namaphesenti. Kodwa-ke, kungenzeka ukuthi udinga ukusebenza ku-Excel ngamanani asefomini izingxenyana ezivamileNjenge 1/2 (umzuzwana owodwa) noma 2/3 (okubili kokuthathu), ngaphandle kokuguqulela kumafrakshini amadesimali.
Isibonelo, sineresiphi yamakhukhi we-chocolate chip futhi sifuna ukuyifometha ku-Microsoft Excel. Iresiphi idinga isithako - 1/4 ithisipuni kasawoti, kumelwe ibhalwe kukholamu B, njengengxenye evamile.
Ngaphambi kokuba siqale ukufaka izithako, sidinga ukushintsha okuthile etafuleni lethu. Njengoba cishe uyakhumbula (kuhlanganise nezifundo zethu), ungasebenzisa ukufometha okukhethekile kunoma iyiphi iseli ku-Excel, okungukuthi ifomethi yenombolo. I-Excel inefomethi yenombolo eyingxenye ekuvumela ukuthi ufake amanani njengamafrakshini. Ukuze senze lokhu, sigqamisa ikholomu B bese kuthebhu Ikhaya (Ekhaya) ohlwini lokudonsela phansi Ifomethi yenombolo (Ifomethi yenombolo) khetha into Ingxenyana (Encane).
Sicela uqaphele ukuthi sisebenza ku-Excel 2013 kulesi sibonelo, kodwa le ndlela izosebenza ku-Excel 2010 no-2007 ngendlela efanayo. Ku-Excel 2003 nangaphambili, khetha amaseli owafunayo bese ucindezela isinqamuleli sekhibhodi Ctrl + 1ukusetha ifomethi yenombolo. Sicela uqaphele ukuthi le nketho ayitholakali ku-Google AmaSpredishithi.
Manje njengoba ifomethi yenombolo isimisiwe, sesilungele ukufaka amafrakshini kukholamu B.
Qaphela ukuthi izinombolo zingavezwa njengezingxenye ezixubile, ngendlela 2 3 / 4 (amakota amabili nantathu). Uma ukhetha elinye lalawa maseli, uzobona kubha yefomula ukuthi i-Excel empeleni iphatha lawo manani njengamadesimali - ifomethi yefraction ishintsha kuphela ukuthi inombolo iboniswa kanjani kuseli. Ngokwesibonelo, 2 3 / 4 kuyafana nokuthi 2.75.
Ungasebenzisa izingxenyana ezivamile kumafomula nemisebenzi. Cabanga ukuthi le recipe ingeyeziphakeli ezimbili zamakhukhi. Uma udinga ukwenza amakhukhi amane, ungakwazi kabili iresiphi usebenzisa i-Excel. Uma sidinga ukuphinda kabili inani likasawoti ku-recipe, kufanele siphindaphinde inani leseli B2 ngalo 2; ifomula izoba kanje: = B2 * 2. Bese singakopisha ifomula kwamanye amaseli kukholamu C ngokukhetha iseli nokuhudula isibambo sokugcwalisa ngokuzenzakalelayo.
Sinamanani amasha ayingxenye yeresiphi yethu ephindwe kabili! Njengoba ubona, ukusebenzisa ifomethi yenombolo enjalo ku-Excel kwenza kube lula kakhulu ukusebenza ngamafrakshini, ikakhulukazi uma ungafuni ukuguqula izingxenyana ezivamile zibe amadesimali.