Momwe 'Kukangana' Kumagwiritsidwira Ntchito Kapena Ntchito

Mikangano ndizofunika zomwe zimagwiritsidwa ntchito kupanga mawerengero. Mu mapulogalamu a spreadsheet monga Excel ndi Google Mapepala, ntchito zimangokhala zokhazokha zomwe zimapanga mawerengedwe ndipo zambiri mwa ntchitozi zimafuna deta kuti ilowemo, kaya ndi wogwiritsa ntchito kapena gwero lina, kuti abweretse zotsatira.

Ntchito Syntax

Mawu ogwira ntchito amatanthauzira momwe ntchitoyo ikuyendera ndipo imaphatikizapo dzina la ntchito, maina, maulendo osiyana, ndi zifukwa zake.

Zokambirana nthawi zonse zikuzunguliridwa ndi mafotokozedwe ndi zifukwa zina zimasiyanitsidwa ndi makasitomala.

Chitsanzo chosavuta, chomwe chikuwonetsedwa pa chithunzi pamwambapa, ndi ntchito ya SUM - yomwe ingagwiritsidwe ntchito powerengera kapena kukhala ndi mizere yaitali kapena mizere yambiri. Chidule cha ntchitoyi ndi:

SUM (Number1, Number2, ... Namba2525)

Zolinga za ntchitoyi ndi: Number1, Number2, ... Number255

Chiwerengero cha zifukwa

Chiwerengero cha zotsutsana kuti ntchito imafuna zimasiyana ndi ntchitoyo. Ntchito ya SUM ikhoza kukhala ndi zifukwa zokwana 255, koma imodzi yokha ikufunika - nambala Number1 - zotsalazo ndizosankha.

Ntchito ya OFFSET, pakadali pano, ili ndi zifukwa zitatu ndi zifukwa ziwiri.

Ntchito zina, monga ZOYENERA ndi ZOYENERA masiku ano , ziribe zifukwa, koma kujambulani deta - nambala yeniyeni kapena tsiku - kuchokera nthawi ya kompyuta. Ngakhale kuti palibe zifukwa zomwe zimafunikanso ndi ntchitozi, zovuta, zomwe ndi mbali ya mgwirizano wa ntchito, ziyenera kuphatikizidwa polowa ntchitoyi.

Mitundu ya Dongosolo muzitsutso

Mofanana ndi chiwerengero cha zifukwa, mitundu ya deta yomwe ingaloweredwe kutsutsana idzakhala yosiyana malinga ndi ntchitoyi.

Pankhani ya ntchito ya SUM, monga momwe tawonetsera pa chithunzi pamwambapa, zifukwa ziyenera kukhala ndi deta - koma deta iyi ikhonza kukhala:

• deta yeniyeni ikukambidwa - kukambirana Number1 mu chithunzi pamwamba;
• selo loyang'ana pa malo a chiwerengero cha chiwerengero mu worksheet - mtsutso Number2;
• mafotokozedwe osiyanasiyana kapena osiyanasiyana - ndemanga Number3;

Mitundu ina ya deta yomwe ingagwiritsidwe ntchito pazitsutso ndi monga:

• deta;
• Zofunika za Boolean ;
• malingaliro olakwika ;
• ntchito zina.

Ntchito Yogwiritsira Ntchito

Zowonongeka kuti ntchito imodzi ilowetsedwe ngati kutsutsana kwa ntchito ina. Ntchitoyi imadziwika ngati ntchito yodyetsa ndipo yatha kuwonjezera mphamvu za pulogalamuyi polemba zovuta.

Mwachitsanzo, sizodziwika kuti ngati akugwira ntchito yokhala ndi chinyama mkati mwake monga momwe tawonetsera m'munsimu.

= IF (A1> 50, IF (A2 <100, A1 * 10, A1 * 25)

Mu chitsanzo ichi, ntchito yachiwiri kapena yamtendere ya IF imagwiritsidwa ntchito ngati ndondomeko ya Value_if_yiyi yeniyeni yoyamba ya IF komanso yogwiritsidwa ntchito kuyesa kachiwiri kachiwiri - ngati deta mu selo A2 ndi yosakwana 100.

Kuchokera ku Excel 2007, mipando 64 yodyetsa imaloledwa mwa njira. Zisanayambe, zinyama zisanu ndi ziwiri zokha zothandizidwa zinkathandizidwa.

Kupeza Ntchito & # 39; s Kukangana

Njira ziwiri zopezera zoyenera kutsutsana pa ntchito iliyonse ndi izi:

• Tsegulani bokosi lazokambirana la ntchito mu Excel;
• Mawindo opangira maofesi mu Excel ndi Google Spreadsheets.

Mabokosi olankhulana a Excel Function

Ntchito zambiri mu Excel zili ndi bokosi lachilankhulo - monga momwe zasonyezedwera ntchito ya SUM mu chithunzi pamwambapa - yomwe imatchula zifukwa zoyenera ndi zodzifunira pa ntchitoyi.

Kutsegula malumikizidwe a ntchito kungatheke ndi:

• kupeza ndi kudumpha pa dzina la ntchito pansi pa Tsambali la kachitidwe ka riboni ;
• ndikudalira njira Yopangira Ntchito yomwe ili pafupi ndi bar ya fomula - monga momwe tawonetsera pa chithunzi pamwambapa.

Zida Zopangira Ntchito: Kujambula Ntchito & # 39; s

Njira yina yodziwira zokhudzana ndi ntchito ku Excel ndi Google Spreadsheets ndi:

1. Dinani pa selo,
2. Lowani chizindikiro chofanana - kulengeza pulogalamu kuti fomu ikulowetsedwa;
3. Lowani dzina la ntchito - pamene mukuyimira, mayina a ntchito zonse kuyambira ndi kalatayo akuwoneka mu chida chopangidwa pansi pa selo yogwira ntchito;
4. Lowetsani mauthenga otseguka - ntchito yowonongeka ndi zifukwa zake zomwe zalembedwa mu tooltip.

Mu Excel, mawindo opangira zida amakhala ndi zifukwa zosankha ndi mabakiteriya apakati ([]). Ena onse adalemba zifukwa zofunikira.

Mu Google Spreadsheets, mawindo a zida zogwiritsira ntchito samasintha pakati pa zifukwa zoyenera ndi zosankha. M'malomwake, zimaphatikizapo chitsanzo komanso chidule cha ntchito yomwe amagwiritsidwa ntchito komanso kufotokozera ndemanga iliyonse.