Yadda za a sanya digiri a saman a fice

Anonim

Yadda za a sanya digiri a saman a fice

Idan, maimakon ƙirar ƙarin ƙirar digiri a saman lambar a Forecel, kuna buƙatar gina lamba a ciki, inda aka bayyana yadda ake bayyana irin wannan lissafin ta amfani da dabaru ta amfani da tsari.

Kara karantawa: Kafa lamba a Microsoft Excel

Hanyar 1: Canza Rajistar Lambar

Zaɓin mafi sauri na ƙara digiri shine canja wurin rajistar don an nuna shi a saman, wanda ya haɗu da yanayin sa. Kuma kodayake wannan aiki ne mai sauri, shirya kowane sel, inda akwai adadin da bukatar a nuna a matsayin digiri.

  1. Na farko, danna maɓallin Hagu akan sel da za a zaɓa, sannan kuma ya sanya murfin ɗakunan ƙasa a cikin "lambar".
  2. Selectel don canja tsarin sa lokacin da ƙara digiri daga sama zuwa Exceler

  3. A ciki, zaɓi zaɓi na "rubutu". Idan an nuna tantanin halitta azaman lamba, ba zai yuwu a aiwatar da gyara ba, don haka wannan matakin ya zama tilas.
  4. Canza tsarin tantanin halitta kafin ƙara digiri daga sama zuwa fice

  5. Yanzu warkar da lkm kuma haskakawa tare da adadi da kake son tsara digiri. Idan har yanzu ya bace, kawai rubuta shi ba tare da sarari ba bayan lambar babba.
  6. Zaɓin lambar don ƙarin motsa jiki zuwa girman hannun-da-man hannu na tsari a Fore Excel

  7. Latsa wurin dama da danna kuma a cikin menu na mahallin wanda ya bayyana, zaɓi "Tsarin tantanin halitta".
  8. Canji don saita tsarin lambar da aka sadaukar don tsara shi azaman digiri daga sama cikin fice

  9. Ya rage kawai don yiwa alamar pemick a cikin "gyara".
  10. Saita sigogi don lamba lokacin da tantance shi azaman digiri daga sama a cikin Forevie

  11. Aiwatar da sabon saiti kuma ku koma teburin, tabbatar da matsayin nuni daidai ne.
  12. Ana bincika yawan lambobi azaman digiri daga sama tare da gyara mai gyara

Hanyar 2: Yin Amfani da haruffa na musamman

Akwai yanayi wanda za'a iya amfani da zaɓin da ya gabata, saboda haka muna ba da shawarar sanin kanku tare da madadin amfani da Siff ɗin na musamman. Zai zama dole don nemo lambar da ta dace wanda aka riga aka nuna a cikin babba, sannan kawai ƙara shi ga tantanin halitta.

Ka lura cewa a cikin wannan tebur kamar yadda manyan rijistar zaka sami lambobi kawai daga 4 zuwa 9, don haka wannan zaɓi bai dace ba idan kana son tantance square ko cube.

  1. Danna Surta shafin inda ka danna "alamomin" kuma buɗe menu tare da dukkan alamu.
  2. Je zuwa Saka Sashe don zaɓar alama ta musamman a matsayin digiri daga sama cikin fice

  3. Don sauƙaƙa na daidaituwa a cikin wannan tebur a cikin "Saita" Drop-saukar menu, saka "babba da ƙananan ƙananan bayanai".
  4. Titteration na musamman haruffa don ƙara digiri daga sama zuwa fice

  5. Nemo akwai lambar da kake son amfani da ita azaman digiri, kuma danna sau biyu a ciki ko danna maɓallin "Manna".
  6. Zaɓi alama ta musamman don ƙarawa kamar daga sama cikin fice

  7. Rufe tebur tare da haruffa kuma ka ga yadda aka nuna matsayin a cikin tantanin halitta bayan babban lambar.
  8. Nasara ƙara alama ce ta musamman a matsayin digiri daga sama cikin fice

Hanyar 3: ƙara daidaituwa

Ikon ƙara daidaituwa mai kyau yana ba ka damar ƙirƙirar nau'ikan lissafin lissafi na kowane irin rikice-rikice kuma saka su cikin tebur. Ayyukan kayan aikin da ke da alhakin daidaituwa ya ƙunshi flank tare da lamba da digiri kuma digiri, ƙari na abin da gaskiya ne:

  1. Je zuwa shafin "Saka" sannan ka fadada "alamomin".
  2. Canji zuwa sashin Saka don ƙara daidaitaccen ilmin lissafi yayin ƙirƙirar digiri a fice

  3. Wannan lokacin zaɓi "daidaituwa".
  4. Bude menu don ƙara daidaituwa na lissafi yayin daɗa lamba daga sama zuwa Fiye

  5. Teburin zai bayyana don daidaituwa wanda za'a iya motsa shi zuwa kowane yanki, sannan kuma buɗe "tsarin" saukar da jerin abubuwan ƙasa.
  6. Bude hanyoyin lissafi na lissafin lissafi don ƙara lambobi da yawa daga sama cikin fice

  7. Daga cikin waɗannan tsarin na yanzu, minalejinsu na iya fahimtar hakan yanzu ya zama dole don zaɓar "index".
  8. Zabi na tsarin lissafin lissafi don ƙara digiri daga sama zuwa fice

  9. Jerin tare da manyan abubuwan manya da ƙananan zasu bayyana - don rubuta digiri da kuke buƙatar zaɓar zaɓi na farko.
  10. Zabi tsarin tsarin don ƙara digiri daga sama zuwa Fiye

  11. A bi, danna kowane murabba'in ƙara kuma rubuta lambobi a cikin su.
  12. Gyara Addara Tsarin Lokacin tantance lambar daga sama a cikin Forevie

  13. Wani ɓangare na tsarin lissafin lissafi yana shirye, amma idan kana buƙatar ƙara wasu sassan sa, yi amfani da sabon editan da aka bayyana, zabar tsarin da suka dace.
  14. Nasara ƙara digiri daga sama yayin da kafa daidaitaccen lissafin lissafi

Kara karantawa