Ukusebenzisa iphuzu bese uchofoza ku-Excel ne-Google Spreadsheets ikuvumela ukuthi usebenzise isikhombisi segundane ukwengeza izingcingo zesifomula kwifomula ngokuchofoza esitokisini esifuna njengoba kuboniswe kusibonelo esithombeni esingenhla.
Iphuzu futhi uchofoze ngokuvamile indlela ekhethwayo yokwengeza izingqikithi zeseli kwifomula noma umsebenzi njengoba kunciphisa ukuthi kungenzeka amaphutha avezwe ngokungafundi kahle noma ngokuthayipha ekubhekiseni kweselula okungalungile.
Le ndlela ingagcina futhi isikhathi esiningi nomzamo lapho udala amafomula kusukela abantu abaningi bebona idatha abafuna ukuyifaka kwifomula kunokubhekisela kweseli.
Ukudala iphuzu lokusebenzisa ifomu bese uchofoza
- Thayipha uphawu olulinganayo (=) esitokisini ukuqala ifomula;
- Chofoza kuseli lokuqala ukungezwa kwifomula. Ireferensi yeseli izovela kufomula, futhi umugqa ohlaza okwesibhakabhaka uzovela kuzungeze iseli elichazwe;
- Cindezela ikhi yokuphazamisa izibalo ekhibhodi (njengobunikazi noma ngaphezulu) ukufaka opharetha kufomula ngemuva kokubhekisela kwelili lokuqala;
- Chofoza kuseli lesibili ukuthi ungeze kwifomula. Ukubhekisela kweseli kuzovela efomini, futhi umugqa obomvu ozobe usuvele uzovela nxazonke eseceleni esilandisiwe;
- Qhubeka ungeza opharetha kanye nezinkomba zefoni kuze kube sekuqedile ifomula;
- Cindezela Faka kwikhibhodi ukuqedela ifomula bese ubuka impendulo esitokisini.
Ukuchofoza nokuchofoza ukushintsha: Ukusebenzisa ama-Keys e-Arrow
Ukuhluka kwephuzu bese uchofoze kuhilela ukusebenzisa okhiye bomcibisholo ekhibhodi ukungena izingcingo zesitfombe kufomula. Imiphumela ifana, futhi empeleni iyindaba nje yokuthandayo mayelana nendlela ekhethiwe.
Ukusebenzisa okhiye bomcibisholo ukufaka izingqikithi zeseli:
- Thayipha uphawu olulinganayo (=) esitokisini ukuqala ifomula;
- Sebenzisa izinkinobho zemicibisholo ekhibhodi ukuze uye esitokisini sokuqala ezosetshenziselwa ifomula - isithenjwa seleseli lensiza lengezwe kwifomula ngemuva kwesibonakaliso esifanayo;
- Cindezela ikhi yokuphazamisa izibalo ekhibhodi - njengobunikazi obuningi noma obuncane - ukungena opharetha kufomula ngemuva kokubhekisela kweseli lokuqala (ukugqama kweselula okusebenzayo kuzobuyela esitokisini equkethe ifomula);
- Sebenzisa izinkinobho zemicibisholo ekhibhodi ukuze uye esitokisini sesibili okufanele sisetshenziswe kwifomula - ireferensi yeselula yesibili ingeziwe kwifomula ngemuva kokuphazamisa izibalo;
- Uma kudingekile, faka opharetha abengeziwe bemathemikhali usebenzisa ikhibhodi elandelwa inkomba yeseli yedatha yefomula
- Uma ifomula seliphelile, cindezela ikhi lokungena kwikhibhodi ukuqedela ifomula bese ubuka impendulo esitokisini.