I-Microsoft Excel: engeza Amaphesenti Kwinombolo

Pin
Send
Share
Send

Ngesikhathi sokubala, kwesinye isikhathi kuyadingeka ukwengeza amaphesenti enanini elithile. Isibonelo, ukuthola izinkomba zamanje zenzuzo, ezikhuphuke ngamaphesenti athile uma kuqhathaniswa nenyanga edlule, udinga ukufaka leli phesenti kwinani lenzuzo lenyanga edlule. Kukhona ezinye izibonelo eziningi lapho udinga ukwenza isenzo esifanayo. Ake sibheke ukwengeza iphesenti enombolweni kwiMicrosoft Excel.

Izenzo zekhompiyutha esitokisini

Ngakho-ke, uma udinga nje ukuthola ukuthi le nombolo izolingana nani, ngemuva kokungeza iphesenti elithile kuyo, khona-ke kufanele ushaye kunoma yiliphi iseli leshidi, noma umugqa wamafomula, isisho ngenqubo elandelayo: "= (inombolo) + (inombolo) * (amaphesenti_value )% ".

Ake sithi sidinga ukubala ukuthi sithola liphi inani uma sifaka kumaphesenti angamashumi amabili. Sibhala le formula elandelayo kunoma isiphi iseli, noma emugqeni wamafomula: "= 140 + 140 * 20%".

Okulandelayo, cindezela inkinobho ENTER kukhibhodi, bese ubona umphumela.

Ukufaka ifomula yezenzo etafuleni

Manje, ake sibheke ukuthi ungangeza kanjani iphesenti elithile kudatha esivele ithebula.

Okokuqala, khetha iseli lapho umphumela uzokhonjiswa khona. Sifaka isibonakaliso "=" kuyo. Okulandelayo, chofoza kuseli equkethe idatha okufanele iphesenti lingezwe kuyo. Faka uphawu "+". Futhi, chofoza kuseli eliqukethe inamba, faka uphawu lokuthi "*". Okulandelayo, sithayipha kukhibhodi inani lamaphesenti okufanele lenyuswe ngalo inani. Ungakhohlwa ukufaka uphawu "%" ngemuva kokufaka leli nani.

Sichofoza inkinobho ethi ENTER kukhibhodi, ngemuva kwalokho kuzovela umphumela wokubala.

Uma ufuna ukunweba le formula kuwo wonke amanani ekholomu etafuleni, vele ume emaphethelweni angakwesokudla weseli lapho kuboniswa khona umphumela. Isikhombisi kufanele siphenduke isiphambano. Chofoza inkinobho yegundane kwesobunxele, futhi ngenkinobho ebekwe phansi, “silula” ifomula phansi kuze kube sekupheleni kwetafula.

Njengoba ukwazi ukubona, umphumela wokuphindaphindeka kwezinombolo ngamaphesenti athile uboniswa namanye amaseli kukholamu.

Sithole ukuthi ukufaka iphesenti enombolweni ku-Microsoft Excel akunzima kangako. Kodwa-ke, abasebenzisi abaningi abazi ukuthi bangakwenza kanjani lokhu futhi bawenze amaphutha. Isibonelo, iphutha elijwayelekile kakhulu ukubhala ifomula ngokusho kwe-algorithm "= (inombolo) + (amaphesenti_value)%", esikhundleni se- "= (inombolo) + (inombolo) * (iphesenti_value)%". Lo mhlahlandlela kufanele usize ukuvikela amaphutha anjalo.

Pin
Send
Share
Send