Kulowa Deta, Malembo, kapena Mafomu ndi Excel IF Function

Bungwe la IF limapanga chisankho ku Excel spreadsheets poyesera mkhalidwe wina kuti awone ngati ndi zoona kapena zabodza. Ngati vutoli ndiloona, ntchitoyo idzachita chinthu chimodzi. Ngati chikhalidwecho ndi chonyenga, chidzachita zosiyana. Phunzirani zambiri za IF IF ntchito pansipa.

Kuchita Mawerengedwe ndi Kulowa Data ndi Ntchito IF

Kulowa Mawerengedwe kapena Numeri ndi Ntchito IF. © Ted French

Syntax ya ntchito imatanthawuza momwe ntchitoyo ikuyendera ndipo imaphatikizapo dzina la ntchito, mabaki, ndi zifukwa .

Chidule cha ntchitoyi ndi:

= NGATI (mayeso a logic, ayamikike ngati ali oona, ayamike ngati akunama)

Mayeso oyenerera nthawi zonse amafanizira pakati pa mfundo ziwiri. Ogwiritsira ntchito akugwiritsidwa ntchito, mwachitsanzo, kuti awone ngati mtengo woyamba uli wamkulu kapena wochepa kuposa wachiwiri, kapena wofanana nawo.

Mwachitsanzo, mu chithunzi apa, mayeso olondola amalinganiza mapindu a antchito omwe ali m'mbali B kuti awone ngati ali oposa $ 30,000.00.

= IF (B2> 30000, B2 * 1%, 300)

Ntchitoyo ikadziwika ngati mayeso amtheradi ndi owona kapena onyenga, amachititsa chimodzi mwa zinthu ziwiri zomwe zimaperekedwa ndi mtengo ngati zowona komanso zogwirizana ngati zifukwa zabodza.

Zochita zomwe ntchitoyo ingathe kuchita ndi izi:

Kuchita mawerengedwe ndi Ntchito IF

Ntchito ya IF ikhoza kupanga zowerengera zosiyana malinga ndi momwe ntchitoyo ikubwezera mtengo weniweni kapena ayi.

Mu chithunzi pamwambapa, ndondomeko imagwiritsidwa ntchito kuwerengera ndalama zotsalira pogwiritsa ntchito mapindu a antchito.

= IF (B2> 30000, B2 * 1%, 300)

Kuchuluka kwa chiwongoladzanja kumawerengedwa pogwiritsa ntchito ndondomeko yomwe imalowa ngati mtengo ngati kukangana kwenikweni. Njirayi imapindula ndalama zomwe zimapezeka mu ndondomeko B ndi 1% ngati malipiro a antchito akuposa $ 30,000.00.

Kulowa Data ndi Ntchito IF

Ntchito ya IF iyeneranso kukhazikitsidwa kuti ikhale ndi deta yachinsinsi mu selo lolunjika. Deta iyi ikhonza kugwiritsidwa ntchito pazinthu zina.

Mu chitsanzo chapamwamba, ngati malipiro a antchito ali osachepera $ 30,000.00, mtengo ngati mkangano wonyenga wasankhidwa kuti uike mlingo wapatali wa $ 300.00 pa kuchotsedwa m'malo mogwiritsa ntchito chiŵerengero.

Zindikirani: Palibe chizindikiro cha dola kapena kulekanitsa comma chinalowa ndi chiwerengero cha 30000 kapena 300 mu ntchitoyo. Kulowera chimodzi kapena zonsezi kumapanga zolakwika mu njirayi.

Kuwonetsera Malemba Athu kapena Kusiya Maselo Osalumikizidwa ndi Excel IF Ntchito

Kulowa Malemba Kapena Kusiya Maselo Osayanjanitsidwa ndi Ntchito IF. © Ted French

Kuwonetsa Mawu kapena Ndemanga Zolemba ndi IF Function

Pokhala ndi malemba olembedwa ndi IF ngati ntchito m'malo mowerengera chiwerengero chingathe kukhala kosavuta kupeza ndi kuŵerenga zotsatira zenizeni pa tsamba.

Chitsanzo cha pamwambapa, ntchito ya IF ikukonzekera kuti aone ngati ophunzira akuyesa mafunso omwe amadziwika bwino kuti adziwe mizinda yayikulu ku malo ambirimbiri ku South Pacific.

Kuyesedwa kwachidziwitso kwa ntchito ya IF ikufananitsa mayankho a ophunzira mu gawo B ndi yankho lolondola lomwe linalowa mu mkangano wokha.

Ngati yankho la wophunzira limagwirizana ndi dzina lolowetsamo mndandanda wamaganizo, mawu oyenerera amavomerezedwa m'ndandanda C. Ngati dzina silikugwirizana, selo silikusowa.

= IF (B2 = "Wellington", "Yolani", "")

Kugwiritsa ntchito mawu amodzi kapena malemba olembedwa mu IF IF ntchito iliyonse yowalowetsamo iyenera kutsekedwa mu ndemanga, monga:

Kusiya Maselo Osasunthika

Monga momwe zasonyezera kufunika ngati mkangano wabodza mu chitsanzo chapamwamba, maselo anasiyidwa opanda kanthu mwa kulowetsa awiri a ndemanga zopanda kanthu ( "" ).