Kodi mawu a syntax ndikuti ndiwagwiritsa ntchito liti mu Excel kapena Google Sheets
Chidule cha ntchito ya Excel kapena Google Sheets spreadsheet imatanthawuza za dongosolo ndi dongosolo la ntchitoyo ndi zifukwa zake. Ntchito mu Excel ndi Google Mapepala ndizowonjezera. Ntchito zonse zimayamba ndi chizindikiro chofanana ( = ) chotsatira ndi dzina la ntchito monga IF, SUM, COUNT, kapena ROUND. Muyenera kugwiritsa ntchito syntax yoyenera pamene mutalowa ntchito ku Excel kapena Google Mapepala kapena mukhoza kupeza uthenga wolakwika.
Zolinga za ntchito zimatanthawuza deta yonse kapena chidziwitso chofunika ndi ntchito. Zokambirana izi ziyenera kulowa mu dongosolo lolondola.
Funso la IF Function Syntax
Mwachitsanzo, chidule cha IF chigwira ntchito mu Excel ndi:
= IF (yolemba_yotheka, Value_if_yowona, Value_if_false)
Kulumikizana ndi Ma Commas
Kuphatikiza pa ndondomeko ya zotsutsana, mawu akuti "syntax" amatanthauzanso kuyika kwa mabwalo oyandikana kapena malemba ozungulira zotsutsana ndi kugwiritsiridwa ntchito kwa comma monga wopatukana pakati pa zotsutsana payekha.
Zindikirani: Kuyambira pamene chigwirizano cha ntchito ya IF chimafuna kuti muthe kusiyanitsa zifukwa zitatu za ntchitoyo, simungagwiritse ntchito comma ngati wopatulira mu chiwerengero chachikulu kuposa chikwi. Ngati mutero, Excel ikuwonetseratu bokosi lakulankhulira lodziwitsidwa kuti likupeza vuto ndi ndondomeko kapena kuti zotsutsana zambiri zafotokozedwa pa ntchitoyi.
Kuwerenga IF Function & # 39; s Syntax
Mwa kutsatira malamulo omwe atchulidwa pamwambapa, mukhoza kuzindikira kuti IF igwira ntchito mu Excel ndi mu Google Mapepala nthawi zambiri ili ndi zifukwa zitatu zomwe zikukonzedwa motere:
- Kukangana_kutsutsana kwambiri
- Kufunika_ku_kutsutsana kwenikweni
- Kufunika_ku_kukangana mkangano
Ngati zifukwazo zimayikidwa motsatizana, ntchitoyo imabwerera uthenga wolakwika kapena imakupatsani yankho limene simukuliyembekezera.
Zosowa ndi Zokambirana Zosankha
Chidziwitso chimodzi chomwe syntax sichikutanthauza ndikomwe kukangana kuli kofunikira kapena kusankha. Pankhani ya ntchito ya IF, mayankho oyambirira ndi achiwiri-Logical_test ndi Value_if_nthano zowona-ziyenera, pamene mfundo yachitatu, Value_if_false ndemanga, ndi yosankha.
Ngati kukangana kwachitatu sikulephereka kuchokera kuntchito ndi chikhalidwe chomwe chikuyesedwa ndi ndondomeko ya Logical_test yofufuza ikuyesa yonyenga, ndiye ntchitoyo ikuwonetsa mawu akuti FALSE mu selo komwe ntchitoyo ili.