Ungawengeza kanjani intshisekelo kwinombolo e-Excel

Anonim

Ngeza inzalo ku-chille ku-Microsoft Excel

Ngesikhathi sokubala, kwesinye isikhathi kuyadingeka ukwengeza inzalo kunombolo ethile. Isibonelo, ukuze ufunde izinkomba zenzuzo zamanje, ezikhuphuke ngamaphesenti athile uma ziqhathaniswa nenyanga edlule, kuyadingeka ukwengeza leli phesenti ngobukhulu bezinzuzo zenyanga edlule. Kunezinye izibonelo eziningi lapho udinga ukwenza isenzo esifanayo. Ake sibheke ukuthi ukwengeza kanjani amaphesenti ngenombolo ku-Microsoft Excel.

Izenzo ze-computing esitokisini

Ngakho-ke, uma nje udinga ukwazi ukuthi inani lizolingana kanjani, ngemuva kokungezwa kwamaphesenti athile kuyo, kulandela noma yisiphi iseli seshidi, noma intambo yefomula, shayela le nkulumo ngokuya ngethempulethi elandelayo: "= (inombolo) + (inombolo) * (value_protentint)%."

Ake sithi sidinga ukubala ukuthi yiliphi inani elivela uma ungeza kumaphesenti angama-140. Sibhala phansi ifomula elilandelayo kunoma yisiphi iseli, noma intambo yefomula: "= 140 + 140 * 20%".

Ifomula yokubala amaphesenti ohlelweni lwe-Microsoft Excel

Okulandelayo, chofoza inkinobho ethi Enter kwikhibhodi, futhi sibheka umphumela.

Amaphesenti wokubala umphumela ku-Microsoft Excel

Ukusetshenziswa kwefomula ukuze kwenziwe etafuleni

Manje, ake sithole ukuthi ukwengeza amaphesenti athile kwidatha esele etafuleni.

Okokuqala, khetha iseli lapho umphumela uzoboniswa khona. Sibeka uphawu kuyo "=". Okulandelayo, chofoza kusethi equkethe imininingwane okufanele yengezwe kuyo. Beka isibonakaliso esithi "+". Futhi, ngokuchofoza esitokisini esinenombolo, beka uphawu "*". Okulandelayo, thayipha inani lamaphesenti kwikhibhodi lapho inani kufanele likhule khona. Ungakhohlwa ngemuva kokufaka leli nani ukubeka uphawu "%".

Ifomula yokubala amaphesenti etafula kuhlelo lwe-Microsoft Excel

Chofoza inkinobho ethi Enter kwikhibhodi, ngemuva kwalokho umphumela wokubala uzokhonjiswa.

Amaphesenti wokubala umphumela ku-Microsoft Excel Program for Ithebula

Uma ufuna ukusabalalisa leli formula kuwo wonke amanani wekholomu etafuleni, bese uvele ube umphetho ongezansi wesokudla seseli lapho umphumela utholwe khona. Isikhombisi kufanele siphenduke isiphambano. Sichofoza inkinobho yegundane kwesobunxele, futhi nge- "Yelule" ifomula phansi kuze kube sekupheleni kwetafula.

Welula ifomula phansi ku-Microsoft Excel

Njengoba ubona, umphumela wokuphindaphinda kwezinombolo kwelinye iphesenti elithile utholwa amanye amaseli kukholamu.

Umphumela wokwelula ifomula phansi kuhlelo lweMicrosoft Excel

Sithole ukuthi ukwengeza amaphesenti enombolo kunombolo ohlelweni lweMicrosoft Excel akunzima kangako. Noma kunjalo, abasebenzisi abaningi abazi ukuthi bakwenze kanjani, futhi benze amaphutha. Isibonelo, iphutha elivame kakhulu ukubhala lefomula ngokuya nge-algorithm "= (inombolo) + (inani_protentint)%" esikhundleni se- "= (inombolo) * (Inombolo_Protentint)%." Le ncwadi kufanele isize ukuvikela amaphutha anjalo.

Funda kabanzi