Chii chinonzi syntax uye ndirini chandingashandisa muExcel kana Google Sheets
Mutsara weExcel kana Google Sheet spreadsheet function inoreva kuve nekurongeka kwebasa uye nharo dzaro. Basa riri muExcel neGoogle Sheets rakagadzirirwa mukati. Izvo zvose zvinotanga nechiyero chakaenzana ( = ) chinotevedzwa nezita rebasa rakadai seFI, SUM, COUNT, kana ROUND. Unofanirwa kushandisa syntax yakarurama pose paunopinda basa muExcel kana Google Sheets kana iwe ungangodaro unowana mhosho yemashoko.
Nharo dzebasa dzinoreva zvose data kana ruzivo runodikanwa nebasa. Izvi zvinopesana zvinofanira kuiswa nenzira yakarurama.
Iyo IF Function Syntax
Semuenzaniso, mazwi ekuti IF anoshanda muExcel ndeokuti:
= IF (Logical_test, Value_if_true, Value_if_false)
Parenthesis uye Commas
Mukuwedzera kune zvakarongwa zvemashoko, izwi rokuti "syntax" rinorevawo kuiswa kwezvikwereti zvakapoteredza kana kuti vabereki pakapoteredza nharo uye kushandiswa kwemazana sekuparadzanisa pakati pezvikonzero zvemunhu mumwe nomumwe.
Cherechedza: Sezvo chirevo chebumbiro reF IF chinoda komma kuti iparadzanise nharo nhatu dzebasa racho, haugoni kushandisa comma separarator muhuwandu hukuru kune chiuru. Kana iwe uchidaro, Excel inoratidza gadziriro yekutarisana kwebhokisi ichikuudza kuti yakawana dambudziko nechirevo kana kuti mhinduro dzakawanda dzakatsanangurwa nokuda kwebasa iri.
Kuverenga IF Function & # 39; s Syntax
Nokutevera mitemo inotaurwa pamusoro apa, unogona kuona kuti iyo IF inoshanda muExcel uye muGoogle Sheets inowanzo ine nharo nhatu dzakarongwa nenzira inotevera:
- Logical_test argument
- Value_if_true argument
- Value_if_false argument
Kana nharo dzacho dzichiiswa mune imwe yakarongeka, basa rinodzorera shoko risina kukanganisa kana kukupa mhinduro yausina kutarisira.
Zvinotarisirwa kana Zvichienderana Nharo
Chimwe chikamu chemashoko iyo syntax isingatauri ndechokuti nharo inobvunzwa kana kusarudza. Muchiitiko chebasa re IF, zvinyorwa zvekutanga uye zvechipiri-Logical_test uye Value_if_chokwadi-nharo-dzinodiwa, nepo nharo yechitatu, Value_if_false argument, inofanirwa.
Kana nharo yechitatu isingabvumirwi kubva mumabasa uye mamiriro ezvinhu akaongororwa nebasa re Logical_test rangano rinotarisa kune zvenhema, ipapo basa rinoratidza izwi FALSE mune sero iyo basa iri.