Ungawengeza kanjani amaphesenti enombolweni ku-Excel. Ifomula, imanuwali, yengeza kukholomu yonke

I-Microsoft Excel ivame ukusetshenziselwa ukwenza imisebenzi ngamaphesenti. Zibaluleke kakhulu ezibalweni zokuthengisa. Isibonelo, udinga ukwazi ukuthi yiziphi izinguquko zevolumu yokuthengisa ezihleliwe. Amathuluzi e-Excel akuvumela ukuthi ungeze izinombolo ngamaphesenti futhi udale amafomula ukuze ubale ngokushesha ukukhuphuka nokwehla kokuthengisa. Ake sithole indlela yokwengeza iphesenti yenani yenani ngokwalo.

Indlela yokwengeza iphesenti nenombolo ngesandla

Cabanga ukuthi kunenani lenombolo lenye inkomba, elikhuphuka ngokuhamba kwesikhathi ngamaphesenti ambalwa, noma ngamaphesenti angamashumi amaningana. Lokhu kwanda kungabalwa kusetshenziswa ukusebenza kwezibalo okulula. Kudingeka ukuthatha inombolo futhi wengeze kuyo umkhiqizo wenombolo efanayo ngamaphesenti athile. Ifomula ibukeka kanje: Isamba senani kanye nephesenti=inombolo+(inombolo*amaphesenti%). Ukuhlola isenzo esibonelweni, sizobhala isimo senkinga. Umthamo wokuqala wokukhiqiza ungamayunithi angama-500, akhula ngo-13% njalo ngenyanga.

1. Udinga ukukhetha iseli kuthebula elidaliwe nanoma iyiphi enye iseli yamahhala. Sibhala kuyo isisho esinedatha evela kusimo. Ungakhohlwa ukubeka uphawu olulinganayo ekuqaleni, ngaphandle kwalokho isenzo ngeke senziwe.

2. Cindezela inkinobho ethi "Enter" - inani olifunayo lizovela kuseli.

Le ndlela yokubala ihilela ukugcwalisa okwengeziwe kumaseli wetafula mathupha. Ukukopisha ngeke kusize, ngoba le nkulumo iqukethe izinombolo ezithile, ayibhekiseli kuseli.

Incazelo yephesenti lezinombolo

Kwesinye isikhathi kuyadingeka ukuthi umbiko ubonise ukuthi inani lenkomba ethile alikhuli ngamaphesenti, kodwa ngefomethi yezinombolo evamile. Kulokhu, iphesenti yenani lokuqala libalwa. Sebenzisa ifomula elandelayo ukuze ubale iphesenti lenombolo: Iphesenti=(Inombolo*Inani lamaphesenti ngefomethi yezinombolo)/100. Masiphinde sithathe izinombolo ezifanayo – 500 no-13%.

1. Udinga ukubhala inani kuseli elihlukile, ngakho likhethe. Sibhala ifomula ngezinombolo ezikhonjisiwe, phambi kwayo kunophawu olulinganayo.

2. Cindezela okuthi “Enter” kukhibhodi bese uthola umphumela.

Kwenzeka ukuthi inkomba ikhula njalo ngamayunithi amaningana, kodwa akwaziwa ukuthi ingakanani njengephesenti. Ekubaleni okunjalo, kukhona nefomula: Umehluko wamaphesenti=(Umehluko/Inombolo)*100.

Phambilini kwatholakala ukuthi umthamo wokuthengisa ukhula ngamayunithi angama-65 ngenyanga. Ake sibale ukuthi yimalini njengephesenti.

1. Udinga ukufaka izinombolo ezaziwayo kwifomula bese uyibhala kuseli enophawu olulinganayo ekuqaleni.

2. Ngemva kokucindezela inkinobho ethi "Enter", umphumela uzoba kuseli.

Akudingekile ukuphindaphinda ngo-100 uma iseli liguqulelwa kufomethi efanelekile - "Iphesenti". Cabangela ukushintsha ifomethi yeseli isinyathelo ngesinyathelo:

1. Udinga ukuchofoza kuseli ekhethiwe nge-RMB - imenyu yokuqukethwe izovuleka. Khetha inketho ethi "Fometha Amaseli".

2. Iwindi lizovuleka lapho ungakhetha khona ifomethi efanelekile. Sithola okufakiwe “Amaphesenti” ohlwini olungakwesokunxele. Uma udinga inombolo ephelele, kufanele ubeke inani elinguziro kukholomu “Inani lezindawo zamadesimali” usebenzisa izinkinobho zemicibisholo noma ngokwenza. Okulandelayo, chofoza "OK".

3. Manje isisho singancishiswa sibe yisenzo esisodwa.

4. Umphumela uzovela ngefomethi yephesenti.

Ukwengeza inombolo nephesenti kusetshenziswa ifomula

Ukwengeza iphesenti lenombolo enombolweni ngokwayo, ungasebenzisa ifomula. Le ndlela iyasiza ezimweni lapho imiphumela yokubala idinga ukugcwalisa ngokushesha itafula.

1. Khetha iseli yamahhala bese uligcwalisa ngefomula. Idatha kufanele ithathwe etafuleni. Ifomula ithi: Inombolo+Inombolo*Amaphesenti.
2. Okokuqala, sibhala uphawu olulinganayo, bese sikhetha iseli ngenombolo, faka ukuhlanganisa, bese uphinda uchofoza kuseli ngenani lokuqala. Sifaka inkanyezi njengophawu lokuphindaphinda, ngemva kwayo – inani lephesenti.

3. Cindezela inkinobho ethi "Enter" ukuze uthole umphumela wesibalo.
4. Gcwalisa amaseli asele wekholomu. Ukuze wenze lokhu, udinga ukukopisha ifomula nge-offset - lokhu kusho ukuthi ukuqokwa kweseli kufomula kuzoshintsha uma uthuthela kuseli elingezansi.

Kukhona umaka oyisikwele ekhoneni leseli elikhethiwe. Kudingekile ukubamba phansi futhi welule ukukhetha kukholamu yonke yetafula.

5. Khipha inkinobho yegundane - wonke amaseli akhethiwe azogcwaliswa.

6. Uma izinombolo zidingeka, ifomethi kufanele ishintshwe. Khetha amaseli anefomula, chofoza kwesokudla kuwo bese uvula imenyu yefomethi. Udinga ukukhetha ifomethi yenombolo bese usetha kabusha inombolo yezindawo zamadesimali.

7. Amanani kuwo wonke amaseli azoba izinombolo.

Ungeza kanjani iphesenti kukholomu

Kunemibiko ngale fomethi, lapho enye yamakholomu ibonisa ukukhula kwephesenti lenkomba esikhathini esithile. Iphesenti alifani ngaso sonke isikhathi, kodwa kungenzeka ukubala ukuguqulwa kwezinkomba usebenzisa isibalo.

1. Sibhala ifomula ngokuvumelana nesimiso esifanayo, kodwa ngaphandle kokubhala izinombolo ngesandla - idatha yetafula kuphela edingekayo. Sengeza umthamo wokuthengisa umkhiqizo wawo ngephesenti lokukhula bese ucindezela u-"Enter".

2. Gcwalisa wonke amaseli ngokukhetha ikhophi. Uma kukhethwe ngomaka oyisikwele, ifomula izokopishelwa kwamanye amaseli nge-offset.

Ukwakha ishadi elinamaphesenti amanani

Ngokwemiphumela yezibalo, kungenzeka ukudweba okulingana okubonakalayo kwetafula - umdwebo. Kuyo ungabona ukuthi yimuphi umkhiqizo odume kakhulu uma kuziwa ekuthengisweni.

1. Khetha amaseli anamanani amaphesenti bese uwakopisha - ukwenza lokhu, chofoza kwesokudla bese uthola into ethi "Kopisha" kumenyu noma usebenzise inhlanganisela yokhiye "Ctrl + C".
2. Iya kuthebhu ethi "Faka" bese ukhetha uhlobo lweshadi, isibonelo, ishadi lophayi.

Isiphetho

Ungangeza iphesenti lenombolo enombolweni ngokwayo ngezindlela ezimbalwa - ngokwenza noma usebenzisa ifomula. Inketho yesibili ingcono ezimeni lapho udinga ukwengeza iphesenti kumanani amaningana. Kungenzeka futhi ukubala amanani ambalwa ngamaphesenti ahlukene okukhula futhi wenze ishadi ukuze uthole ukucaca okukhulu kombiko.