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
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:
- kupanga mawerengedwe pogwiritsira ntchito ndondomeko kapena kulowetsa deta
- kusonyeza malongosoledwe a malemba mumaselo olembedwa a worksheet,
- kusiya khungu lolunjika losalekeza.
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.
- Excel ikugwiritsira ntchito chida ngati cholekanitsa pakati pa zifukwa, kotero kulowa ma makasitomala ndi manambala kumatsogolera Excel kuti akhulupirire kuti zoposa zifukwa zitatu zalowa mu ntchito ya IF.
- Popeza zizindikiro za dollar ndizolemba, kulowetsa ndi ziwerengero zimatsogolera Excel kuti akhulupirire kuti cholakwika chayimiridwa chapangidwa ndipo chimapereka kuwongolera.
Kuwonetsera Malemba Athu kapena Kusiya Maselo Osalumikizidwa ndi Excel IF Ntchito
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:
- Mtsutso woyesedwa woganiza: B2 = "Wellington"
- mtengo ngati chowonadi "Cholondola"
Kusiya Maselo Osasunthika
Monga momwe zasonyezera kufunika ngati mkangano wabodza mu chitsanzo chapamwamba, maselo anasiyidwa opanda kanthu mwa kulowetsa awiri a ndemanga zopanda kanthu ( "" ).